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 1083: pay_assignment_actions paa,

1079: CURSOR csr_first_name IS
1080: SELECT substr(papf.first_name||' '||papf.middle_names,1,20)
1081: FROM per_people_f papf,
1082: per_assignments_f paf,
1083: pay_assignment_actions paa,
1084: pay_payroll_actions ppa
1085: WHERE paa.assignment_action_id = p_run_assignment_action_id
1086: AND paf.assignment_id = paa.assignment_id
1087: AND paf.person_id = papf.person_id

Line 1122: pay_assignment_actions paa,

1118: CURSOR csr_last_name is
1119: SELECT substr(papf.last_name,1,20)
1120: FROM per_people_f papf,
1121: per_assignments_f paf,
1122: pay_assignment_actions paa,
1123: pay_payroll_actions ppa
1124: WHERE paa.assignment_action_id = p_run_assignment_action_id
1125: AND paf.assignment_id = paa.assignment_id
1126: AND paf.person_id = papf.person_id

Line 1162: pay_assignment_actions paa,

1158: CURSOR csr_dob IS
1159: SELECT to_char(papf.date_of_birth,'dd-mon-yyyy')
1160: FROM per_people_f papf,
1161: per_assignments_f paf,
1162: pay_assignment_actions paa,
1163: pay_payroll_actions ppa
1164: WHERE paa.assignment_action_id = p_run_assignment_action_id
1165: AND paf.assignment_id = paa.assignment_id
1166: AND paf.person_id = papf.person_id

Line 1358: c_assg_action_id pay_assignment_actions.assignment_action_id%TYPE) IS

1354: v_Cur_Act_Contexts Cur_Act_Contexts%ROWTYPE;
1355:
1356: -- Added for Bug 2545070 to handle PAYROLL REVERSALS
1357: CURSOR csr_get_reversal_action_id(
1358: c_assg_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1359: SELECT max(paa_rev.assignment_action_id)
1360: FROM pay_assignment_actions paa_src
1361: ,pay_assignment_actions paa_rev
1362: ,pay_assignment_actions paa_cur

Line 1360: FROM pay_assignment_actions paa_src

1356: -- Added for Bug 2545070 to handle PAYROLL REVERSALS
1357: CURSOR csr_get_reversal_action_id(
1358: c_assg_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1359: SELECT max(paa_rev.assignment_action_id)
1360: FROM pay_assignment_actions paa_src
1361: ,pay_assignment_actions paa_rev
1362: ,pay_assignment_actions paa_cur
1363: ,pay_payroll_actions ppa_rev
1364: ,pay_action_interlocks pai_rev

Line 1361: ,pay_assignment_actions paa_rev

1357: CURSOR csr_get_reversal_action_id(
1358: c_assg_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1359: SELECT max(paa_rev.assignment_action_id)
1360: FROM pay_assignment_actions paa_src
1361: ,pay_assignment_actions paa_rev
1362: ,pay_assignment_actions paa_cur
1363: ,pay_payroll_actions ppa_rev
1364: ,pay_action_interlocks pai_rev
1365: WHERE paa_cur.assignment_action_id = c_assg_action_id

Line 1362: ,pay_assignment_actions paa_cur

1358: c_assg_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
1359: SELECT max(paa_rev.assignment_action_id)
1360: FROM pay_assignment_actions paa_src
1361: ,pay_assignment_actions paa_rev
1362: ,pay_assignment_actions paa_cur
1363: ,pay_payroll_actions ppa_rev
1364: ,pay_action_interlocks pai_rev
1365: WHERE paa_cur.assignment_action_id = c_assg_action_id
1366: AND paa_src.source_action_id = paa_cur.source_action_id

Line 2161: pay_assignment_actions act,

2157: act.tax_unit_id tax_unit_id
2158: FROM pay_payroll_actions ppa,
2159: pay_payroll_actions appa,
2160: pay_payroll_actions appa2,
2161: pay_assignment_actions act,
2162: pay_assignment_actions act1,
2163: pay_action_interlocks pai,
2164: per_assignments_f as1
2165: WHERE ppa.payroll_action_id = p_pact_id

Line 2162: pay_assignment_actions act1,

2158: FROM pay_payroll_actions ppa,
2159: pay_payroll_actions appa,
2160: pay_payroll_actions appa2,
2161: pay_assignment_actions act,
2162: pay_assignment_actions act1,
2163: pay_action_interlocks pai,
2164: per_assignments_f as1
2165: WHERE ppa.payroll_action_id = p_pact_id
2166: AND appa.consolidation_set_id = p_consolidation_id

Line 2187: pay_assignment_actions act2,

2183: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
2184: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
2185: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
2186: FROM pay_action_interlocks pai1,
2187: pay_assignment_actions act2,
2188: pay_payroll_actions appa3
2189: WHERE pai1.locked_action_id = act.assignment_action_id
2190: AND act2.assignment_action_id = pai1.locking_action_id
2191: AND act2.payroll_action_id = appa3.payroll_action_id

Line 2212: pay_assignment_actions act,

2208: act.tax_unit_id tax_unit_id
2209: FROM pay_payroll_actions ppa,
2210: pay_payroll_actions appa,
2211: pay_payroll_actions appa2,
2212: pay_assignment_actions act,
2213: pay_assignment_actions act1,
2214: pay_action_interlocks pai,
2215: per_assignments_f as1,
2216: pay_population_ranges ppr

Line 2213: pay_assignment_actions act1,

2209: FROM pay_payroll_actions ppa,
2210: pay_payroll_actions appa,
2211: pay_payroll_actions appa2,
2212: pay_assignment_actions act,
2213: pay_assignment_actions act1,
2214: pay_action_interlocks pai,
2215: per_assignments_f as1,
2216: pay_population_ranges ppr
2217: WHERE ppa.payroll_action_id = p_pact_id

Line 2240: pay_assignment_actions act2,

2236: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
2237: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
2238: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
2239: FROM pay_action_interlocks pai1,
2240: pay_assignment_actions act2,
2241: pay_payroll_actions appa3
2242: WHERE pai1.locked_action_id = act.assignment_action_id
2243: AND act2.assignment_action_id = pai1.locking_action_id
2244: AND act2.payroll_action_id = appa3.payroll_action_id

Line 2309: SELECT pay_assignment_actions_s.NEXTVAL

2305: IF l_prepay_action_id <> csr_rec.prepaid_action_id
2306:
2307: THEN
2308:
2309: SELECT pay_assignment_actions_s.NEXTVAL
2310: INTO l_actid
2311: FROM dual;
2312:
2313: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 2347: SELECT pay_assignment_actions_s.NEXTVAL

2343: IF l_prepay_action_id <> csr_rec.prepaid_action_id
2344:
2345: THEN
2346:
2347: SELECT pay_assignment_actions_s.NEXTVAL
2348: INTO l_actid
2349: FROM dual;
2350:
2351: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 2407: pay_assignment_actions assact,

2403: FROM pay_action_interlocks pre,
2404: pay_action_interlocks pay,
2405: pay_payroll_actions paa,
2406: pay_payroll_actions ppaa,
2407: pay_assignment_actions assact,
2408: pay_assignment_actions passact,
2409: per_time_periods ptp -- added to fetch correct time period id
2410: WHERE pre.locked_action_id = pay.locked_action_id
2411: AND pre.locking_action_id = p_locking_action_id

Line 2408: pay_assignment_actions passact,

2404: pay_action_interlocks pay,
2405: pay_payroll_actions paa,
2406: pay_payroll_actions ppaa,
2407: pay_assignment_actions assact,
2408: pay_assignment_actions passact,
2409: per_time_periods ptp -- added to fetch correct time period id
2410: WHERE pre.locked_action_id = pay.locked_action_id
2411: AND pre.locking_action_id = p_locking_action_id
2412: AND pre.locked_action_id = assact.assignment_action_id

Line 2431: FROM pay_assignment_actions paa,

2427: p_assignment_id NUMBER,
2428: p_effective_date DATE ) IS
2429: SELECT paa.assignment_action_id child_assignment_action_id,
2430: 'S' run_type
2431: FROM pay_assignment_actions paa,
2432: pay_run_types_f prt
2433: WHERE paa.source_action_id = p_master_assignment_action
2434: AND paa.payroll_action_id = p_payroll_action_id
2435: AND paa.assignment_id = p_assignment_id

Line 2443: FROM pay_assignment_actions paa

2439: prt.effective_start_date AND prt.effective_end_date
2440: UNION
2441: SELECT paa.assignment_action_id child_assignment_action_id,
2442: 'NP' run_type
2443: FROM pay_assignment_actions paa
2444: WHERE paa.payroll_action_id = p_payroll_action_id
2445: AND paa.assignment_id = p_assignment_id
2446: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2447: FROM pay_assignment_actions paa1,

Line 2447: FROM pay_assignment_actions paa1,

2443: FROM pay_assignment_actions paa
2444: WHERE paa.payroll_action_id = p_payroll_action_id
2445: AND paa.assignment_id = p_assignment_id
2446: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2447: FROM pay_assignment_actions paa1,
2448: pay_run_types_f prt1
2449: WHERE prt1.run_type_id = paa1.run_type_id
2450: AND prt1.run_method IN ('N','P')
2451: AND paa1.payroll_action_id = p_payroll_action_id

Line 2462: FROM pay_assignment_actions paa,

2458: CURSOR csr_child_actions(p_assignment_id NUMBER,
2459: p_effective_date DATE ) IS
2460: /*SELECT paa.assignment_action_id child_assignment_action_id,
2461: 'S' run_type
2462: FROM pay_assignment_actions paa,
2463: pay_run_types_f prt
2464: WHERE paa.run_type_id = prt.run_type_id
2465: AND prt.run_method = 'S'
2466: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2470: FROM pay_assignment_actions paa,

2466: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2467: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2468: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2469: paa.assignment_action_id),16)) child_assignment_action_id
2470: FROM pay_assignment_actions paa,
2471: pay_payroll_actions ppa
2472: WHERE paa.assignment_id = p_assignment_id
2473: AND ppa.payroll_action_id = paa.payroll_action_id
2474: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))

Line 2482: FROM pay_assignment_actions paa,

2478: UNION */
2479: -- Bug Fix 4260031
2480: SELECT paa.assignment_action_id child_assignment_action_id,
2481: prt.run_method run_type
2482: FROM pay_assignment_actions paa,
2483: pay_run_types_f prt
2484: WHERE paa.run_type_id = prt.run_type_id
2485: AND prt.run_method IN ('N','P')
2486: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2490: FROM pay_assignment_actions paa,

2486: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2487: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2488: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2489: paa.assignment_action_id),16)) child_assignment_action_id
2490: FROM pay_assignment_actions paa,
2491: pay_payroll_actions ppa
2492: WHERE paa.assignment_id = p_assignment_id
2493: AND ppa.payroll_action_id = paa.payroll_action_id
2494: AND (paa.source_action_id is not null or ppa.action_type in ('I','V'))

Line 2507: FROM pay_assignment_actions paa,

2503: p_assignment_id NUMBER,
2504: p_effective_date DATE) IS
2505: SELECT paa.assignment_action_id np_assignment_action_id,
2506: prt.run_method
2507: FROM pay_assignment_actions paa,
2508: pay_run_types_f prt
2509: WHERE paa.source_action_id = p_assignment_action_id
2510: AND paa.payroll_action_id = p_payroll_action_id
2511: AND paa.assignment_id = p_assignment_id

Line 2522: FROM pay_assignment_actions paa,

2518: /*CURSOR csr_np_children (p_assignment_id NUMBER,
2519: p_effective_date DATE) IS
2520: SELECT paa.assignment_action_id np_assignment_action_id,
2521: prt.run_method
2522: FROM pay_assignment_actions paa,
2523: pay_run_types_f prt
2524: WHERE paa.run_type_id = prt.run_type_id
2525: AND prt.run_method IN ('N','P')
2526: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date

Line 2530: FROM pay_assignment_actions paa,

2526: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2527: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2528: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2529: paa.assignment_action_id),16))
2530: FROM pay_assignment_actions paa,
2531: pay_payroll_actions ppa
2532: WHERE paa.assignment_id = p_assignment_id
2533: AND ppa.payroll_action_id = paa.payroll_action_id
2534: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))

Line 2567: FROM pay_assignment_actions paa

2563: -- retrieve the chunk number for the current assignment action
2564:
2565: SELECT paa.chunk_number
2566: INTO l_chunk_number
2567: FROM pay_assignment_actions paa
2568: WHERE paa.assignment_action_id = p_assactid;
2569:
2570: l_action_context_id := p_assactid;
2571:

Line 2614: SELECT pay_assignment_actions_s.NEXTVAL

2610: LOOP
2611:
2612: -- create additional archive assignment actions and interlocks
2613:
2614: SELECT pay_assignment_actions_s.NEXTVAL
2615: INTO l_actid
2616: FROM dual;
2617:
2618: hr_utility.set_location('csr_child_rec.run_type = ' || csr_child_rec.run_type,30);

Line 2892: FROM pay_assignment_actions paa,

2888: AND (pact.action_type = 'P' OR
2889: pact.action_type = 'U')
2890: AND pact.action_status = 'C'
2891: AND exists (SELECT NULL
2892: FROM pay_assignment_actions paa,
2893: pay_action_interlocks pai,
2894: pay_assignment_actions paa_arc
2895: WHERE pai.locked_action_id = paa.assignment_action_id
2896: AND pai.locking_action_id = paa_arc.assignment_action_id

Line 2894: pay_assignment_actions paa_arc

2890: AND pact.action_status = 'C'
2891: AND exists (SELECT NULL
2892: FROM pay_assignment_actions paa,
2893: pay_action_interlocks pai,
2894: pay_assignment_actions paa_arc
2895: WHERE pai.locked_action_id = paa.assignment_action_id
2896: AND pai.locking_action_id = paa_arc.assignment_action_id
2897: AND paa_arc.payroll_action_id = p_pact_id
2898: AND paa.payroll_action_id = pact.payroll_action_id)