eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 171: FROM pay_payroll_actions

167: ) + LENGTH(p_token)
168: )
169: )),
170: TRIM(business_group_id)
171: FROM pay_payroll_actions
172: WHERE payroll_action_id = p_pact_id;
173:
174: l_business_group_id VARCHAR2(300);
175: l_token_value VARCHAR2(300);

Line 204: FROM pay_payroll_actions

200: LENGTH(legislative_parameters)
201: )
202: )
203:
204: FROM pay_payroll_actions
205: WHERE payroll_action_id = p_pact_id;
206:
207:
208: BEGIN

Line 464: FROM pay_payroll_actions

460: l_comments varchar2(300);
461:
462: CURSOR csr_archive_effective_date(pactid NUMBER) IS
463: SELECT effective_date
464: FROM pay_payroll_actions
465: WHERE payroll_action_id = pactid;
466:
467: CURSOR csr_employer_details(c_org_id hr_organization_information.organization_id%type
468: ,c_bg_id hr_organization_units.business_group_id%type) IS

Line 555: ' pay_payroll_actions pa' ||

551: hr_utility.set_location('pactid '||TO_CHAR(pactid), 300);
552:
553: sqlstr := ' select distinct p.person_id' ||
554: ' from per_people_f p,' ||
555: ' pay_payroll_actions pa' ||
556: ' where pa.payroll_action_id = :payroll_action_id' ||
557: ' and p.business_group_id = pa.business_group_id' ||
558: ' order by p.person_id';
559:

Line 792: pay_payroll_actions ppa,

788: l_select_str :='select distinct paaf.assignment_id asgid
789: from per_all_assignments_f paaf,
790: per_all_people_f ppf,
791: pay_all_payrolls_f papf,
792: pay_payroll_actions ppa,
793: hr_soft_coding_keyflex scl
794: where paaf.business_group_id = '|| g_business_group_id
795: ||' and papf.business_group_id = paaf.business_group_id '
796: ||' and paaf.effective_start_date <= '||''''||g_qtr_end_date||''''

Line 865: FROM pay_payroll_actions

861:
862:
863: CURSOR csr_archive_effective_date(pactid NUMBER) IS
864: SELECT effective_date
865: FROM pay_payroll_actions
866: WHERE payroll_action_id = pactid;
867:
868: BEGIN
869:

Line 977: pay_payroll_actions ppa

973: IS
974: SELECT /*+ USE_NL(paa, ppa) */
975: max(paa.assignment_action_id) assignment_action_id
976: FROM pay_assignment_actions paa,
977: pay_payroll_actions ppa
978: WHERE paa.assignment_id = p_asg_id
979: AND ppa.payroll_action_id = paa.payroll_action_id
980: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))
981: AND ppa.effective_date between g_qtr_start_date and g_qtr_end_date

Line 1757: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

1753: l_blob PAY_FILE_DETAILS.BLOB_FILE_FRAGMENT%TYPE;
1754:
1755: l_person_id per_all_people_f.person_id%TYPE;
1756: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1757: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1758: l_object_action_id pay_temp_object_actions.object_action_id%TYPE;
1759:
1760: CURSOR C_Perid_Asgid(p_payroll_action_id NUMBER, p_object_action_id NUMBER) IS
1761: SELECT DISTINCT ppf.person_id, paa.assignment_id

Line 1764: ,pay_payroll_actions ppa

1760: CURSOR C_Perid_Asgid(p_payroll_action_id NUMBER, p_object_action_id NUMBER) IS
1761: SELECT DISTINCT ppf.person_id, paa.assignment_id
1762: FROM per_all_people_f ppf
1763: ,per_all_assignments_f paa
1764: ,pay_payroll_actions ppa
1765: ,pay_temp_object_actions ptoa
1766: WHERE paa.business_group_id = ppa.business_group_id
1767: AND paa.person_id = ppf.person_id
1768: AND ppa.payroll_action_id = p_payroll_action_id

Line 2453: pay_payroll_actions ppa

2449: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2450: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2451: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2452: FROM pay_assignment_actions paa,
2453: pay_payroll_actions ppa
2454: WHERE
2455: paa.assignment_id = paaf.assignment_id
2456: AND ppa.payroll_action_id = paa.payroll_action_id
2457: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))

Line 2562: pay_payroll_actions ppa

2558: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2559: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2560: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2561: FROM pay_assignment_actions paa,
2562: pay_payroll_actions ppa
2563: WHERE
2564: paa.assignment_id = paaf.assignment_id
2565: AND ppa.payroll_action_id = paa.payroll_action_id
2566: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))

Line 2679: pay_payroll_actions ppa

2675: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2676: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2677: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2678: FROM pay_assignment_actions paa,
2679: pay_payroll_actions ppa
2680: WHERE
2681: paa.assignment_id = paaf.assignment_id
2682: AND ppa.payroll_action_id = paa.payroll_action_id
2683: AND (paa.source_action_id is not null or ppa.action_type in ('I','V'))

Line 2812: pay_payroll_actions ppa

2808: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2809: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2810: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2811: FROM pay_assignment_actions paa,
2812: pay_payroll_actions ppa
2813: WHERE
2814: paa.assignment_id = paaf.assignment_id
2815: AND ppa.payroll_action_id = paa.payroll_action_id
2816: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))