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_P35 dependencies on PAY_PAYROLL_ACTIONS

Line 119: pay_payroll_actions ppa,

115: cursor csr_get_max_assact is
116: SELECT MAX(paa.assignment_action_id)
117: FROM per_assignments_f paf,
118: pay_assignment_actions paa,
119: pay_payroll_actions ppa,
120: per_time_periods ptp
121: WHERE paf.person_id = l_person_id
122: AND paf.assignment_id = paa.assignment_id
123: AND paa.action_status = 'C'

Line 243: pay_payroll_actions ppa,

239: trim(rrv1.result_value) result_value
240: FROM per_people_f per,
241: per_assignments_f asg,
242: pay_assignment_actions paa,
243: pay_payroll_actions ppa,
244: per_time_periods ptp,
245: pay_run_results prr,
246: pay_element_types_f pet,
247: pay_input_values_f piv1,

Line 600: FROM pay_payroll_actions

596: + LENGTH (p_token)
597: )
598: ),
599: business_group_id bg_id
600: FROM pay_payroll_actions
601: WHERE payroll_action_id = p_pact_id;
602:
603: l_business_group_id NUMBER;
604: l_token_value VARCHAR2 (50);

Line 678: FROM pay_payroll_actions ppa

674: --
675: CURSOR csr_p30_process
676: IS
677: SELECT NVL (MIN (ppa.payroll_action_id), 0)
678: FROM pay_payroll_actions ppa
679: WHERE ppa.report_type = 'IEP30_PRGLOCK'
680: AND ppa.action_status = 'C'
681: AND TO_DATE (
682: pay_ie_p35.get_parameter (

Line 732: pay_payroll_actions ppa

728: hr_utility.set_location ('End Date 3',22);
729: sqlstr := 'select distinct asg.person_id
730: from per_periods_of_service pos,
731: per_assignments_f asg,
732: pay_payroll_actions ppa
733: where ppa.payroll_action_id = :payroll_action_id
734: and pos.person_id = asg.person_id
735: and pos.period_of_service_id = asg.period_of_service_id
736: and pos.business_group_id = ppa.business_group_id

Line 802: pay_payroll_actions ppa,

798: paa.assignment_id,
799: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa -- Bug 4672715
800: FROM per_assignments_f asg,
801: pay_assignment_actions paa,
802: pay_payroll_actions ppa,
803: pay_all_payrolls_f pap,
804: per_time_periods ptp,
805: hr_soft_coding_keyflex flex
806: WHERE paa.source_action_id IS NULL

Line 831: pay_payroll_actions ppa1,

827: AND asg.effective_end_date = DECODE(OVERRIDE_PPSN(asg.assignment_id),NULL, --6633719
828: (SELECT MAX (paf.effective_end_date)
829: FROM per_assignments_f paf,
830: pay_assignment_actions paa1, --Bug fix 4130665
831: pay_payroll_actions ppa1,
832: per_time_periods ptp1 --Tar 15081088.6
833: ,pay_all_payrolls_f pay
834: ,hr_soft_coding_keyflex flex1
835: WHERE paf.person_id = asg.person_id

Line 910: pay_payroll_actions ppa_p35,

906: OR l_assignment_set_id IS NULL)
907: AND NOT EXISTS (
908: SELECT 1
909: FROM pay_assignment_actions paa_p35,
910: pay_payroll_actions ppa_p35,
911: per_assignments_f paaf_p35,
912: pay_all_payrolls_f ppf_p35,
913: hr_soft_coding_keyflex flex_p35,
914: pay_action_interlocks plock

Line 971: pay_payroll_actions ppa

967: pay_run_results prr,
968: pay_input_values_f pivf,
969: pay_element_types_f pet,
970: pay_assignment_actions paa,
971: pay_payroll_actions ppa
972: WHERE ppa.payroll_action_id= paa.payroll_action_id
973: AND ((paa.source_action_id= p_action_id
974: AND prr.assignment_action_id = paa.assignment_action_id )
975: OR (paa.assignment_action_id = p_action_id AND prr.assignment_action_id = paa.assignment_action_id ))

Line 986: pay_payroll_actions ppa

982:
983: CURSOR csr_action_type (p_assignment_id NUMBER) IS
984: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
985: FROM pay_assignment_actions paa,
986: pay_payroll_actions ppa
987: WHERE ppa.payroll_action_id = paa.payroll_action_id
988: and paa.assignment_id = p_assignment_id
989: and ppa.action_type in ('R','Q')
990: and paa.source_action_id is null

Line 995: l_flag_action_type pay_payroll_actions.action_type%TYPE;

991: AND ppa.effective_date between l_start_date AND l_end_date;
992:
993:
994: l_flag_exclusion varchar2(1) := 'N';
995: l_flag_action_type pay_payroll_actions.action_type%TYPE;
996: l_flag_action_id pay_assignment_actions.assignment_action_id%TYPE;
997: BEGIN
998:
999: --

Line 1252: pay_payroll_actions ppa

1248: IS
1249: SELECT paa.assignment_action_id,ppa.action_type
1250: FROM pay_action_interlocks pal,
1251: pay_assignment_actions paa,
1252: pay_payroll_actions ppa
1253: WHERE pal.locked_action_id = p_action_id
1254: AND pal.locking_action_id = paa.assignment_action_id
1255: AND ppa.payroll_action_id = paa.payroll_action_id
1256: AND paa.action_status = 'C'

Line 1268: from pay_payroll_actions ppa,

1264: ORDER BY paa.assignment_action_id DESC;
1265:
1266: /*CURSOR get_action_type(p_action_id number) is
1267: select ppa.action_type, ppa.report_type
1268: from pay_payroll_actions ppa,
1269: pay_assignment_actions paa
1270: where ppa.payroll_action_id = paa.payroll_action_id
1271: and paa.source_action_id IS NULL
1272: and paa.assignment_action_id = p_action_id;*/

Line 1282: pay_payroll_actions ppa,

1278: IS
1279: SELECT paa.assignment_action_id
1280: FROM pay_action_interlocks pal,
1281: pay_assignment_actions paa,
1282: pay_payroll_actions ppa,
1283: pay_action_information pai
1284: WHERE pal.locked_action_id = p_asg_act_id
1285: AND pal.locking_action_id = paa.assignment_action_id
1286: AND paa.source_action_id IS NULL

Line 1303: pay_payroll_actions ppa

1299: IS
1300: SELECT paa.assignment_action_id
1301: FROM pay_action_interlocks pal,
1302: pay_assignment_actions paa,
1303: pay_payroll_actions ppa
1304: WHERE pal.locked_action_id = p_asg_act_id
1305: AND pal.locking_action_id = paa.assignment_action_id
1306: AND ppa.payroll_action_id = paa.payroll_action_id
1307: AND paa.action_status = 'C'

Line 1640: pay_payroll_actions ppa

1636: per_assignments_f paf,
1637: per_addresses pad,
1638: -- pay_ie_paye_details_f payef, --Bug 4154171
1639: pay_all_payrolls_f papf,
1640: pay_payroll_actions ppa
1641: WHERE pai.locking_action_id = p_locked_action
1642: AND paa.assignment_action_id = pai.locked_action_id
1643: -- Added for bug 5874653
1644: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1843: pay_payroll_actions ppa

1839: per_assignments_f paf,
1840: per_addresses pad,
1841: -- pay_ie_paye_details_f payef,
1842: pay_all_payrolls_f papf,
1843: pay_payroll_actions ppa
1844: WHERE paa.assignment_action_id = p_locked_action
1845: -- Added for bug 5874653
1846: AND ppa.payroll_action_id = paa.payroll_action_id
1847: AND ppa.effective_date BETWEEN nvl(pad.date_from,ppa.effective_date) AND nvl(pad.date_to,ppa.effective_date)

Line 2010: pay_payroll_actions ppa

2006:
2007: CURSOR c_get_max_aact(p_pds_id NUMBER) IS
2008: SELECT max(paa.assignment_action_id)
2009: FROM pay_assignment_Actions paa,
2010: pay_payroll_actions ppa
2011: -- ,per_time_periods ptp -- removed to improve performance 4771780
2012: WHERE paa.assignment_id in (SELECT assignment_id
2013: FROM per_assignments_f
2014: WHERE period_of_service_id = p_pds_id)

Line 2086: v_action_type pay_payroll_actions.action_type%TYPE;

2082:
2083: --6633719
2084:
2085: cnt number;
2086: v_action_type pay_payroll_actions.action_type%TYPE;
2087: v_report_type pay_payroll_actions.report_type%TYPE;
2088: v_work_number per_assignments_f.assignment_number%TYPE;
2089: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2090: v_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 2087: v_report_type pay_payroll_actions.report_type%TYPE;

2083: --6633719
2084:
2085: cnt number;
2086: v_action_type pay_payroll_actions.action_type%TYPE;
2087: v_report_type pay_payroll_actions.report_type%TYPE;
2088: v_work_number per_assignments_f.assignment_number%TYPE;
2089: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2090: v_action_id pay_assignment_actions.assignment_action_id%TYPE;
2091: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

Line 2091: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

2087: v_report_type pay_payroll_actions.report_type%TYPE;
2088: v_work_number per_assignments_f.assignment_number%TYPE;
2089: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2090: v_action_id pay_assignment_actions.assignment_action_id%TYPE;
2091: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2092: v_chunk pay_assignment_actions.chunk_number%TYPE;
2093: l_max_assignment_id per_assignments_f.assignment_id%TYPE;
2094: v_date date;
2095: asg_assignment_id per_assignments_f.assignment_id%TYPE;

Line 2140: pay_payroll_actions ppa

2136: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2137: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2138: paa.assignment_action_id),16)) child_assignment_action_id
2139: FROM pay_assignment_actions paa,
2140: pay_payroll_actions ppa
2141: WHERE paa.assignment_id = p_asg_id
2142: AND ppa.payroll_action_id = paa.payroll_action_id
2143: AND (paa.source_action_id is not null or ppa.action_type in ('I','V'))
2144: AND ppa.effective_date between trunc(p_effective_date,'Y') and p_effective_date

Line 4573: pay_payroll_actions ppa,

4569: NVL (TRIM (RPAD (hl.TELEPHONE_NUMBER_1, 12)), ' ' ), -- ('CONTACT_NUMBER=P'),
4570: NVL (TRIM (RPAD (hl.TELEPHONE_NUMBER_2, 12)), ' ') --('FAX_NO=P') /*Added for bug fix 3815830*/
4571: FROM hr_all_organization_units hou,
4572: hr_locations hl,
4573: pay_payroll_actions ppa,
4574: hr_organization_information hoi1,
4575: hr_organization_information hoi2
4576: WHERE ppa.payroll_action_id = p_payroll_action_id
4577: AND hou.business_group_id = ppa.business_group_id

Line 4677: pay_payroll_actions ppa,

4673: paa.assignment_action_id),16)) assignment_action_id --bug fix 4004470
4674: FROM per_people_f ppf,
4675: per_assignments_f paf,
4676: pay_assignment_actions paa,
4677: pay_payroll_actions ppa,
4678: per_time_periods ptp
4679: WHERE
4680: ppf.person_id = p_person_id
4681: AND paf.assignment_id = p_assignment_id -- vik added code for getting values for given assignment

Line 4722: pay_payroll_actions ppa,

4718: trim(rrv1.result_value) result_value
4719: FROM per_people_f per,
4720: per_assignments_f asg,
4721: pay_assignment_actions paa,
4722: pay_payroll_actions ppa,
4723: per_time_periods ptp,
4724: pay_run_results prr,
4725: pay_element_types_f pet,
4726: pay_input_values_f piv1,

Line 4842: pay_payroll_actions ppa,

4838: ) class_name
4839: FROM per_people_f per,
4840: per_assignments_f asg,
4841: pay_assignment_actions paa,
4842: pay_payroll_actions ppa,
4843: per_time_periods ptp,
4844: pay_run_results prr,
4845: pay_element_types_f pet,
4846: pay_input_values_f piv1,