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 126: pay_payroll_actions ppa,

122: cursor csr_get_max_assact is
123: SELECT MAX(paa.assignment_action_id)
124: FROM per_assignments_f paf,
125: pay_assignment_actions paa,
126: pay_payroll_actions ppa,
127: per_time_periods ptp
128: WHERE paf.person_id = l_person_id
129: AND paf.assignment_id = paa.assignment_id
130: AND paa.action_status IN ('C','S') --10225372

Line 250: pay_payroll_actions ppa,

246: trim(rrv1.result_value) result_value
247: FROM per_people_f per,
248: per_assignments_f asg,
249: pay_assignment_actions paa,
250: pay_payroll_actions ppa,
251: per_time_periods ptp,
252: pay_run_results prr,
253: pay_element_types_f pet,
254: pay_input_values_f piv1,

Line 607: FROM pay_payroll_actions

603: + LENGTH (p_token)
604: )
605: ),
606: business_group_id bg_id
607: FROM pay_payroll_actions
608: WHERE payroll_action_id = p_pact_id;
609:
610: l_business_group_id NUMBER;
611: l_token_value VARCHAR2 (50);

Line 685: FROM pay_payroll_actions ppa

681: --
682: CURSOR csr_p30_process
683: IS
684: SELECT NVL (MIN (ppa.payroll_action_id), 0)
685: FROM pay_payroll_actions ppa
686: WHERE ppa.report_type = 'IEP30_PRGLOCK'
687: AND ppa.action_status = 'C'
688: AND TO_DATE (
689: pay_ie_p35.get_parameter (

Line 739: pay_payroll_actions ppa

735: hr_utility.set_location ('End Date 3',22);
736: sqlstr := 'select distinct asg.person_id
737: from per_periods_of_service pos,
738: per_assignments_f asg,
739: pay_payroll_actions ppa
740: where ppa.payroll_action_id = :payroll_action_id
741: and pos.person_id = asg.person_id
742: and pos.period_of_service_id = asg.period_of_service_id
743: and pos.business_group_id = ppa.business_group_id

Line 810: pay_payroll_actions ppa,

806: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa -- Bug 4672715
807: ,fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aamin -- 8322991
808: FROM per_assignments_f asg,
809: pay_assignment_actions paa,
810: pay_payroll_actions ppa,
811: pay_all_payrolls_f pap,
812: per_time_periods ptp,
813: hr_soft_coding_keyflex flex
814: WHERE paa.source_action_id IS NULL

Line 839: pay_payroll_actions ppa1,

835: AND asg.effective_end_date = DECODE(OVERRIDE_PPSN(asg.assignment_id),NULL, --6633719
836: (SELECT MAX (paf.effective_end_date)
837: FROM per_assignments_f paf,
838: pay_assignment_actions paa1, --Bug fix 4130665
839: pay_payroll_actions ppa1,
840: per_time_periods ptp1 --Tar 15081088.6
841: ,pay_all_payrolls_f pay
842: ,hr_soft_coding_keyflex flex1
843: WHERE paf.person_id = asg.person_id

Line 918: pay_payroll_actions ppa_p35,

914: OR l_assignment_set_id IS NULL)
915: AND NOT EXISTS (
916: SELECT 1
917: FROM pay_assignment_actions paa_p35,
918: pay_payroll_actions ppa_p35,
919: per_assignments_f paaf_p35,
920: pay_all_payrolls_f ppf_p35,
921: hr_soft_coding_keyflex flex_p35,
922: pay_action_interlocks plock

Line 980: pay_payroll_actions ppa

976: pay_run_results prr,
977: pay_input_values_f pivf,
978: pay_element_types_f pet,
979: pay_assignment_actions paa,
980: pay_payroll_actions ppa
981: WHERE ppa.payroll_action_id= paa.payroll_action_id
982: AND ((paa.source_action_id= p_action_id
983: AND prr.assignment_action_id = paa.assignment_action_id )
984: OR (paa.assignment_action_id = p_action_id AND prr.assignment_action_id = paa.assignment_action_id ))

Line 1002: pay_payroll_actions ppa

998: pay_run_results prr,
999: pay_input_values_f pivf,
1000: pay_element_types_f pet,
1001: pay_assignment_actions paa,
1002: pay_payroll_actions ppa
1003: WHERE ppa.payroll_action_id= paa.payroll_action_id
1004: AND paa.assignment_id = p_asg_id
1005: AND ((paa.source_action_id between p_action_id_min AND p_action_id_max
1006: AND prr.assignment_action_id = paa.assignment_action_id )

Line 1170: pay_payroll_actions ppa

1166: CURSOR csr_action_type (p_assignment_id NUMBER) IS
1167: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
1168: , fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_min --12382953
1169: FROM pay_assignment_actions paa,
1170: pay_payroll_actions ppa
1171: WHERE ppa.payroll_action_id = paa.payroll_action_id
1172: and paa.assignment_id = p_assignment_id
1173: and ppa.action_type in ('R','Q')
1174: and paa.source_action_id is null

Line 1179: l_flag_action_type pay_payroll_actions.action_type%TYPE;

1175: AND ppa.effective_date between l_start_date AND l_end_date;
1176:
1177:
1178: l_flag_exclusion varchar2(1) := 'N';
1179: l_flag_action_type pay_payroll_actions.action_type%TYPE;
1180: l_flag_action_id pay_assignment_actions.assignment_action_id%TYPE;
1181:
1182: --12382953
1183: l_min_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 1557: pay_payroll_actions ppa

1553: IS
1554: SELECT paa.assignment_action_id,ppa.action_type
1555: FROM pay_action_interlocks pal,
1556: pay_assignment_actions paa,
1557: pay_payroll_actions ppa
1558: WHERE pal.locked_action_id = p_action_id
1559: AND pal.locking_action_id = paa.assignment_action_id
1560: AND ppa.payroll_action_id = paa.payroll_action_id
1561: AND paa.action_status IN ('C','S') --10225372

Line 1573: from pay_payroll_actions ppa,

1569: ORDER BY paa.assignment_action_id DESC;
1570:
1571: /*CURSOR get_action_type(p_action_id number) is
1572: select ppa.action_type, ppa.report_type
1573: from pay_payroll_actions ppa,
1574: pay_assignment_actions paa
1575: where ppa.payroll_action_id = paa.payroll_action_id
1576: and paa.source_action_id IS NULL
1577: and paa.assignment_action_id = p_action_id;*/

Line 1587: pay_payroll_actions ppa,

1583: IS
1584: SELECT paa.assignment_action_id
1585: FROM pay_action_interlocks pal,
1586: pay_assignment_actions paa,
1587: pay_payroll_actions ppa,
1588: pay_action_information pai
1589: WHERE pal.locked_action_id = p_asg_act_id
1590: AND pal.locking_action_id = paa.assignment_action_id
1591: AND paa.source_action_id IS NULL

Line 1608: pay_payroll_actions ppa

1604: IS
1605: SELECT paa.assignment_action_id
1606: FROM pay_action_interlocks pal,
1607: pay_assignment_actions paa,
1608: pay_payroll_actions ppa
1609: WHERE pal.locked_action_id = p_asg_act_id
1610: AND pal.locking_action_id = paa.assignment_action_id
1611: AND ppa.payroll_action_id = paa.payroll_action_id
1612: AND paa.action_status = 'C'

Line 2013: pay_payroll_actions ppa

2009: per_assignments_f paf,
2010: per_addresses pad,
2011: -- pay_ie_paye_details_f payef, --Bug 4154171
2012: pay_all_payrolls_f papf,
2013: pay_payroll_actions ppa
2014: WHERE pai.locking_action_id = p_locked_action
2015: AND paa.assignment_action_id = pai.locked_action_id
2016: -- Added for bug 5874653
2017: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2250: pay_payroll_actions ppa

2246: per_assignments_f paf,
2247: per_addresses pad,
2248: -- pay_ie_paye_details_f payef,
2249: pay_all_payrolls_f papf,
2250: pay_payroll_actions ppa
2251: WHERE paa.assignment_action_id = p_locked_action
2252: -- Added for bug 5874653
2253: AND ppa.payroll_action_id = paa.payroll_action_id
2254: AND ppa.effective_date BETWEEN nvl(pad.date_from,ppa.effective_date) AND nvl(pad.date_to,ppa.effective_date)

Line 2426: pay_payroll_actions ppa

2422: /*
2423: CURSOR c_get_max_aact(p_pds_id NUMBER) IS
2424: SELECT max(paa.assignment_action_id)
2425: FROM pay_assignment_Actions paa,
2426: pay_payroll_actions ppa
2427: -- ,per_time_periods ptp -- removed to improve performance 4771780
2428: WHERE paa.assignment_id in (SELECT assignment_id
2429: FROM per_assignments_f
2430: WHERE period_of_service_id = p_pds_id)

Line 2449: pay_payroll_actions ppa

2445: c_person_id NUMBER) IS
2446: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2447: paa.assignment_action_id),16))
2448: FROM pay_assignment_Actions paa,
2449: pay_payroll_actions ppa
2450:
2451: WHERE ( (c_ppsn is null and paa.assignment_id in (SELECT paf.assignment_id
2452: FROM per_assignments_f paf
2453: WHERE paf.period_of_service_id = p_pds_id

Line 2532: v_action_type pay_payroll_actions.action_type%TYPE;

2528:
2529: --6633719
2530:
2531: cnt number;
2532: v_action_type pay_payroll_actions.action_type%TYPE;
2533: v_report_type pay_payroll_actions.report_type%TYPE;
2534: v_work_number per_assignments_f.assignment_number%TYPE;
2535: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2536: v_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 2533: v_report_type pay_payroll_actions.report_type%TYPE;

2529: --6633719
2530:
2531: cnt number;
2532: v_action_type pay_payroll_actions.action_type%TYPE;
2533: v_report_type pay_payroll_actions.report_type%TYPE;
2534: v_work_number per_assignments_f.assignment_number%TYPE;
2535: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2536: v_action_id pay_assignment_actions.assignment_action_id%TYPE;
2537: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

Line 2537: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

2533: v_report_type pay_payroll_actions.report_type%TYPE;
2534: v_work_number per_assignments_f.assignment_number%TYPE;
2535: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2536: v_action_id pay_assignment_actions.assignment_action_id%TYPE;
2537: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2538: v_chunk pay_assignment_actions.chunk_number%TYPE;
2539: l_max_assignment_id per_assignments_f.assignment_id%TYPE;
2540: v_date date;
2541: asg_assignment_id per_assignments_f.assignment_id%TYPE;

Line 2589: pay_payroll_actions ppa

2585: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2586: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2587: paa.assignment_action_id),16)) child_assignment_action_id
2588: FROM pay_assignment_actions paa,
2589: pay_payroll_actions ppa
2590: WHERE paa.assignment_id = p_asg_id
2591: AND ppa.payroll_action_id = paa.payroll_action_id
2592: AND (paa.source_action_id is not null or ppa.action_type in ('I','V'))
2593: AND ppa.effective_date between trunc(p_effective_date,'Y') and p_effective_date

Line 2617: pay_payroll_actions ppa

2613: SELECT
2614: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_max
2615: ,fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id_min
2616: FROM pay_assignment_actions paa,
2617: pay_payroll_actions ppa
2618: WHERE ppa.payroll_action_id = paa.payroll_action_id
2619: and paa.assignment_id = p_assignment_id
2620: and ppa.action_type in ('R','Q')
2621: and paa.source_action_id is null

Line 2635: pay_payroll_actions ppa

2631: pay_run_results prr,
2632: pay_input_values_f pivf,
2633: pay_element_types_f pet,
2634: pay_assignment_actions paa,
2635: pay_payroll_actions ppa
2636: WHERE ppa.payroll_action_id= paa.payroll_action_id
2637: AND paa.assignment_id = p_asg_id
2638: AND ((paa.source_action_id between p_action_id_min AND p_action_id_max
2639: AND prr.assignment_action_id = paa.assignment_action_id )

Line 7601: pay_payroll_actions ppa,

7597: , NVL (TRIM (RPAD (hl.LOCATION_CODE, 30)), ' ') -- 10277535
7598: , NVL (TRIM (RPAD (hoi3.ORG_INFORMATION2, 30)), ' ') -- 12556436 EMAIL ADDRESS
7599: FROM hr_all_organization_units hou,
7600: hr_locations hl,
7601: pay_payroll_actions ppa,
7602: hr_organization_information hoi1,
7603: hr_organization_information hoi2
7604: ,hr_organization_information hoi3 --12556436
7605: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 7741: pay_payroll_actions ppa,

7737: paa.assignment_action_id),16)) assignment_action_id --bug fix 4004470
7738: FROM per_people_f ppf,
7739: per_assignments_f paf,
7740: pay_assignment_actions paa,
7741: pay_payroll_actions ppa,
7742: per_time_periods ptp
7743: WHERE
7744: ppf.person_id = p_person_id
7745: AND paf.assignment_id = p_assignment_id -- vik added code for getting values for given assignment

Line 7787: pay_payroll_actions ppa,

7783: trim(rrv1.result_value) result_value
7784: FROM per_people_f per,
7785: per_assignments_f asg,
7786: pay_assignment_actions paa,
7787: pay_payroll_actions ppa,
7788: per_time_periods ptp,
7789: pay_run_results prr,
7790: pay_element_types_f pet,
7791: pay_input_values_f piv1,

Line 7909: pay_payroll_actions ppa,

7905: ) class_name
7906: FROM per_people_f per,
7907: per_assignments_f asg,
7908: pay_assignment_actions paa,
7909: pay_payroll_actions ppa,
7910: per_time_periods ptp,
7911: pay_run_results prr,
7912: pay_element_types_f pet,
7913: pay_input_values_f piv1,

Line 8019: pay_payroll_actions ppa,

8015: ptp.time_period_id
8016: FROM per_people_f per,
8017: per_assignments_f asg,
8018: pay_assignment_actions paa,
8019: pay_payroll_actions ppa,
8020: per_time_periods ptp,
8021: pay_run_results prr,
8022: pay_element_types_f pet,
8023: pay_input_values_f piv1,