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_LEGISLATIVE_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 138: pay_assignment_actions paa1, -- prepayment action

134: ,'BIK Arrearage'
135: ,sum (fnd_number.canonical_to_number (prv.result_value * (- 1)))
136: ,sum (fnd_number.canonical_to_number (prv.result_value))) numeric_value
137: FROM pay_action_interlocks lck, -- archive action locking prepayment
138: pay_assignment_actions paa1, -- prepayment action
139: pay_assignment_actions paa2, -- archive action
140: pay_payroll_actions ppa, -- prepayment
141: pay_action_information pai, -- archived element/input value definition
142: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay

Line 139: pay_assignment_actions paa2, -- archive action

135: ,sum (fnd_number.canonical_to_number (prv.result_value * (- 1)))
136: ,sum (fnd_number.canonical_to_number (prv.result_value))) numeric_value
137: FROM pay_action_interlocks lck, -- archive action locking prepayment
138: pay_assignment_actions paa1, -- prepayment action
139: pay_assignment_actions paa2, -- archive action
140: pay_payroll_actions ppa, -- prepayment
141: pay_action_information pai, -- archived element/input value definition
142: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
143: pay_assignment_actions paa, -- payroll run/quickpay action

Line 143: pay_assignment_actions paa, -- payroll run/quickpay action

139: pay_assignment_actions paa2, -- archive action
140: pay_payroll_actions ppa, -- prepayment
141: pay_action_information pai, -- archived element/input value definition
142: pay_action_interlocks pac, -- prepayment locking payroll run/quickpay
143: pay_assignment_actions paa, -- payroll run/quickpay action
144: pay_payroll_actions ppa1, -- payroll run/quickpay action
145: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
146: pay_input_values_f piv, -- "Pay values" of type Money
147: pay_run_results prr, -- run result created by the payroll run/quick pay

Line 207: pay_assignment_actions paa

203: then
204: select paa.assignment_id, ppa.effective_date
205: into l_assignment_id, l_effective_date
206: from pay_payroll_actions ppa,
207: pay_assignment_actions paa
208: where paa.assignment_action_id = p_assignment_action_id
209: and paa.payroll_action_id = ppa.payroll_action_id;
210:
211: else

Line 1304: pay_assignment_actions paa,

1300: CURSOR csr_first_name IS
1301: SELECT substr(papf.first_name||' '||papf.middle_names,1,20)
1302: FROM per_people_f papf,
1303: per_assignments_f paf,
1304: pay_assignment_actions paa,
1305: pay_payroll_actions ppa
1306: WHERE paa.assignment_action_id = p_run_assignment_action_id
1307: AND paf.assignment_id = paa.assignment_id
1308: AND paf.person_id = papf.person_id

Line 1343: pay_assignment_actions paa,

1339: CURSOR csr_last_name is
1340: SELECT substr(papf.last_name,1,20)
1341: FROM per_people_f papf,
1342: per_assignments_f paf,
1343: pay_assignment_actions paa,
1344: pay_payroll_actions ppa
1345: WHERE paa.assignment_action_id = p_run_assignment_action_id
1346: AND paf.assignment_id = paa.assignment_id
1347: AND paf.person_id = papf.person_id

Line 1383: pay_assignment_actions paa,

1379: CURSOR csr_dob IS
1380: SELECT to_char(papf.date_of_birth,'dd-mon-yyyy')
1381: FROM per_people_f papf,
1382: per_assignments_f paf,
1383: pay_assignment_actions paa,
1384: pay_payroll_actions ppa
1385: WHERE paa.assignment_action_id = p_run_assignment_action_id
1386: AND paf.assignment_id = paa.assignment_id
1387: AND paf.person_id = papf.person_id

Line 1579: c_assg_action_id pay_assignment_actions.assignment_action_id%TYPE) IS

1575: v_Cur_Act_Contexts Cur_Act_Contexts%ROWTYPE;
1576:
1577: -- Added for Bug 2545070 to handle PAYROLL REVERSALS
1578: CURSOR csr_get_reversal_action_id(
1579: c_assg_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1580: SELECT max(paa_rev.assignment_action_id)
1581: FROM pay_assignment_actions paa_src
1582: ,pay_assignment_actions paa_rev
1583: ,pay_assignment_actions paa_cur

Line 1581: FROM pay_assignment_actions paa_src

1577: -- Added for Bug 2545070 to handle PAYROLL REVERSALS
1578: CURSOR csr_get_reversal_action_id(
1579: c_assg_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1580: SELECT max(paa_rev.assignment_action_id)
1581: FROM pay_assignment_actions paa_src
1582: ,pay_assignment_actions paa_rev
1583: ,pay_assignment_actions paa_cur
1584: ,pay_payroll_actions ppa_rev
1585: ,pay_action_interlocks pai_rev

Line 1582: ,pay_assignment_actions paa_rev

1578: CURSOR csr_get_reversal_action_id(
1579: c_assg_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1580: SELECT max(paa_rev.assignment_action_id)
1581: FROM pay_assignment_actions paa_src
1582: ,pay_assignment_actions paa_rev
1583: ,pay_assignment_actions paa_cur
1584: ,pay_payroll_actions ppa_rev
1585: ,pay_action_interlocks pai_rev
1586: WHERE paa_cur.assignment_action_id = c_assg_action_id

Line 1583: ,pay_assignment_actions paa_cur

1579: c_assg_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1580: SELECT max(paa_rev.assignment_action_id)
1581: FROM pay_assignment_actions paa_src
1582: ,pay_assignment_actions paa_rev
1583: ,pay_assignment_actions paa_cur
1584: ,pay_payroll_actions ppa_rev
1585: ,pay_action_interlocks pai_rev
1586: WHERE paa_cur.assignment_action_id = c_assg_action_id
1587: AND paa_src.source_action_id = paa_cur.source_action_id

Line 1743: FROM pay_assignment_actions paa1,

1739: Cursor c_other_child_asg_act_id(p_assignment_id NUMBER, p_effective_date DATE, p_child_asg_act_id NUMBER)
1740: IS
1741: SELECT paa1.assignment_action_id child_assignment_action_id
1742: ,prt.run_method run_type
1743: FROM pay_assignment_actions paa1,
1744: pay_run_types_f prt
1745: WHERE paa1.run_type_id = prt.run_type_id
1746: AND prt.run_method IN ('N','P')
1747: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 1752: FROM pay_assignment_actions paa,

1748: AND paa1.assignment_action_id IN
1749: (SELECT /*+ USE_NL(paa, ppa) */
1750: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1751: paa.assignment_action_id),16)) child_assignment_action_id
1752: FROM pay_assignment_actions paa,
1753: pay_payroll_actions ppa
1754: WHERE paa.assignment_id = p_assignment_id
1755: AND fnd_number.canonical_to_number(substr(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id,16)) <> p_child_asg_act_id
1756: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2458: pay_assignment_actions act,

2454: act.tax_unit_id tax_unit_id
2455: FROM pay_payroll_actions ppa,
2456: pay_payroll_actions appa,
2457: pay_payroll_actions appa2,
2458: pay_assignment_actions act,
2459: pay_assignment_actions act1,
2460: pay_action_interlocks pai,
2461: per_assignments_f as1
2462: WHERE ppa.payroll_action_id = p_pact_id

Line 2459: pay_assignment_actions act1,

2455: FROM pay_payroll_actions ppa,
2456: pay_payroll_actions appa,
2457: pay_payroll_actions appa2,
2458: pay_assignment_actions act,
2459: pay_assignment_actions act1,
2460: pay_action_interlocks pai,
2461: per_assignments_f as1
2462: WHERE ppa.payroll_action_id = p_pact_id
2463: AND appa.consolidation_set_id = p_consolidation_id

Line 2484: pay_assignment_actions act2,

2480: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
2481: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
2482: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
2483: FROM pay_action_interlocks pai1,
2484: pay_assignment_actions act2,
2485: pay_payroll_actions appa3
2486: WHERE pai1.locked_action_id = act.assignment_action_id
2487: AND act2.assignment_action_id = pai1.locking_action_id
2488: AND act2.payroll_action_id = appa3.payroll_action_id

Line 2509: pay_assignment_actions act,

2505: act.tax_unit_id tax_unit_id
2506: FROM pay_payroll_actions ppa,
2507: pay_payroll_actions appa,
2508: pay_payroll_actions appa2,
2509: pay_assignment_actions act,
2510: pay_assignment_actions act1,
2511: pay_action_interlocks pai,
2512: per_assignments_f as1,
2513: pay_population_ranges ppr

Line 2510: pay_assignment_actions act1,

2506: FROM pay_payroll_actions ppa,
2507: pay_payroll_actions appa,
2508: pay_payroll_actions appa2,
2509: pay_assignment_actions act,
2510: pay_assignment_actions act1,
2511: pay_action_interlocks pai,
2512: per_assignments_f as1,
2513: pay_population_ranges ppr
2514: WHERE ppa.payroll_action_id = p_pact_id

Line 2537: pay_assignment_actions act2,

2533: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
2534: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
2535: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
2536: FROM pay_action_interlocks pai1,
2537: pay_assignment_actions act2,
2538: pay_payroll_actions appa3
2539: WHERE pai1.locked_action_id = act.assignment_action_id
2540: AND act2.assignment_action_id = pai1.locking_action_id
2541: AND act2.payroll_action_id = appa3.payroll_action_id

Line 2606: SELECT pay_assignment_actions_s.NEXTVAL

2602: IF l_prepay_action_id <> csr_rec.prepaid_action_id
2603:
2604: THEN
2605:
2606: SELECT pay_assignment_actions_s.NEXTVAL
2607: INTO l_actid
2608: FROM dual;
2609:
2610: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 2644: SELECT pay_assignment_actions_s.NEXTVAL

2640: IF l_prepay_action_id <> csr_rec.prepaid_action_id
2641:
2642: THEN
2643:
2644: SELECT pay_assignment_actions_s.NEXTVAL
2645: INTO l_actid
2646: FROM dual;
2647:
2648: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 2704: pay_assignment_actions assact,

2700: FROM pay_action_interlocks pre,
2701: pay_action_interlocks pay,
2702: pay_payroll_actions paa,
2703: pay_payroll_actions ppaa,
2704: pay_assignment_actions assact,
2705: pay_assignment_actions passact,
2706: per_time_periods ptp -- added to fetch correct time period id
2707: WHERE pre.locked_action_id = pay.locked_action_id
2708: AND pre.locking_action_id = p_locking_action_id

Line 2705: pay_assignment_actions passact,

2701: pay_action_interlocks pay,
2702: pay_payroll_actions paa,
2703: pay_payroll_actions ppaa,
2704: pay_assignment_actions assact,
2705: pay_assignment_actions passact,
2706: per_time_periods ptp -- added to fetch correct time period id
2707: WHERE pre.locked_action_id = pay.locked_action_id
2708: AND pre.locking_action_id = p_locking_action_id
2709: AND pre.locked_action_id = assact.assignment_action_id

Line 2720: (select 1 from pay_assignment_actions paa1

2716: AND paa.payroll_id = ptp.payroll_id
2717: AND paa.date_earned between ptp.start_date and ptp.end_date
2718: --11926918
2719: AND EXISTS
2720: (select 1 from pay_assignment_actions paa1
2721: where
2722: paa1.payroll_action_id = assact.payroll_action_id
2723: and paa1.action_status = 'C'
2724: and paa1.source_action_id = assact.assignment_action_id

Line 2737: FROM pay_assignment_actions paa,

2733: p_assignment_id NUMBER,
2734: p_effective_date DATE ) IS
2735: SELECT paa.assignment_action_id child_assignment_action_id,
2736: 'S' run_type
2737: FROM pay_assignment_actions paa,
2738: pay_run_types_f prt
2739: WHERE paa.source_action_id = p_master_assignment_action
2740: AND paa.payroll_action_id = p_payroll_action_id
2741: AND paa.assignment_id = p_assignment_id

Line 2749: FROM pay_assignment_actions paa

2745: prt.effective_start_date AND prt.effective_end_date
2746: UNION
2747: SELECT paa.assignment_action_id child_assignment_action_id,
2748: 'NP' run_type
2749: FROM pay_assignment_actions paa
2750: WHERE paa.payroll_action_id = p_payroll_action_id
2751: AND paa.assignment_id = p_assignment_id
2752: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2753: FROM pay_assignment_actions paa1,

Line 2753: FROM pay_assignment_actions paa1,

2749: FROM pay_assignment_actions paa
2750: WHERE paa.payroll_action_id = p_payroll_action_id
2751: AND paa.assignment_id = p_assignment_id
2752: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2753: FROM pay_assignment_actions paa1,
2754: pay_run_types_f prt1
2755: WHERE prt1.run_type_id = paa1.run_type_id
2756: AND prt1.run_method IN ('N','P')
2757: AND paa1.payroll_action_id = p_payroll_action_id

Line 2768: FROM pay_assignment_actions paa,

2764: CURSOR csr_child_actions(p_assignment_id NUMBER,
2765: p_effective_date DATE ) IS
2766: /*SELECT paa.assignment_action_id child_assignment_action_id,
2767: 'S' run_type
2768: FROM pay_assignment_actions paa,
2769: pay_run_types_f prt
2770: WHERE paa.run_type_id = prt.run_type_id
2771: AND prt.run_method = 'S'
2772: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2776: FROM pay_assignment_actions paa,

2772: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2773: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2774: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2775: paa.assignment_action_id),16)) child_assignment_action_id
2776: FROM pay_assignment_actions paa,
2777: pay_payroll_actions ppa
2778: WHERE paa.assignment_id = p_assignment_id
2779: AND ppa.payroll_action_id = paa.payroll_action_id
2780: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))

Line 2788: FROM pay_assignment_actions paa,

2784: UNION */
2785: -- Bug Fix 4260031
2786: SELECT paa.assignment_action_id child_assignment_action_id,
2787: prt.run_method run_type
2788: FROM pay_assignment_actions paa,
2789: pay_run_types_f prt
2790: WHERE paa.run_type_id = prt.run_type_id
2791: AND prt.run_method IN ('N','P')
2792: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2796: FROM pay_assignment_actions paa,

2792: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2793: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2794: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2795: paa.assignment_action_id),16)) child_assignment_action_id
2796: FROM pay_assignment_actions paa,
2797: pay_payroll_actions ppa
2798: WHERE paa.assignment_id = p_assignment_id
2799: AND ppa.payroll_action_id = paa.payroll_action_id
2800: AND (paa.source_action_id is not null or ppa.action_type in ('I','V'))

Line 2813: FROM pay_assignment_actions paa,

2809: p_assignment_id NUMBER,
2810: p_effective_date DATE) IS
2811: SELECT paa.assignment_action_id np_assignment_action_id,
2812: prt.run_method
2813: FROM pay_assignment_actions paa,
2814: pay_run_types_f prt
2815: WHERE paa.source_action_id = p_assignment_action_id
2816: AND paa.payroll_action_id = p_payroll_action_id
2817: AND paa.assignment_id = p_assignment_id

Line 2828: FROM pay_assignment_actions paa,

2824: /*CURSOR csr_np_children (p_assignment_id NUMBER,
2825: p_effective_date DATE) IS
2826: SELECT paa.assignment_action_id np_assignment_action_id,
2827: prt.run_method
2828: FROM pay_assignment_actions paa,
2829: pay_run_types_f prt
2830: WHERE paa.run_type_id = prt.run_type_id
2831: AND prt.run_method IN ('N','P')
2832: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2836: FROM pay_assignment_actions paa,

2832: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2833: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2834: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2835: paa.assignment_action_id),16))
2836: FROM pay_assignment_actions paa,
2837: pay_payroll_actions ppa
2838: WHERE paa.assignment_id = p_assignment_id
2839: AND ppa.payroll_action_id = paa.payroll_action_id
2840: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))

Line 2873: FROM pay_assignment_actions paa

2869: -- retrieve the chunk number for the current assignment action
2870:
2871: SELECT paa.chunk_number
2872: INTO l_chunk_number
2873: FROM pay_assignment_actions paa
2874: WHERE paa.assignment_action_id = p_assactid;
2875:
2876: l_action_context_id := p_assactid;
2877:

Line 2920: SELECT pay_assignment_actions_s.NEXTVAL

2916: LOOP
2917:
2918: -- create additional archive assignment actions and interlocks
2919:
2920: SELECT pay_assignment_actions_s.NEXTVAL
2921: INTO l_actid
2922: FROM dual;
2923:
2924: hr_utility.set_location('csr_child_rec.run_type = ' || csr_child_rec.run_type,30);

Line 3207: FROM pay_assignment_actions paa,

3203: AND (pact.action_type = 'P' OR
3204: pact.action_type = 'U')
3205: AND pact.action_status = 'C'
3206: AND exists (SELECT NULL
3207: FROM pay_assignment_actions paa,
3208: pay_action_interlocks pai,
3209: pay_assignment_actions paa_arc
3210: WHERE pai.locked_action_id = paa.assignment_action_id
3211: AND pai.locking_action_id = paa_arc.assignment_action_id

Line 3209: pay_assignment_actions paa_arc

3205: AND pact.action_status = 'C'
3206: AND exists (SELECT NULL
3207: FROM pay_assignment_actions paa,
3208: pay_action_interlocks pai,
3209: pay_assignment_actions paa_arc
3210: WHERE pai.locked_action_id = paa.assignment_action_id
3211: AND pai.locking_action_id = paa_arc.assignment_action_id
3212: AND paa_arc.payroll_action_id = p_pact_id
3213: AND paa.payroll_action_id = pact.payroll_action_id)