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_PAYROLL_ACTIONS

Line 71: FROM pay_payroll_actions

67: INSTR(legislative_parameters,' ',
68: INSTR(legislative_parameters,p_token))
69: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token))),
70: business_group_id
71: FROM pay_payroll_actions
72: WHERE payroll_action_id = p_pact_id;
73:
74: l_business_group_id VARCHAR2(20);
75: l_token_value VARCHAR2(50);

Line 140: pay_payroll_actions ppa, -- prepayment

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
144: pay_payroll_actions ppa1, -- payroll run/quickpay action

Line 144: pay_payroll_actions ppa1, -- payroll run/quickpay 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
148: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay

Line 206: from pay_payroll_actions ppa,

202: if (p_assignment_id is null or p_effective_date is null)
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:

Line 941: FROM pay_payroll_actions

937: IS
938:
939: CURSOR csr_archive_effective_date(pactid NUMBER) IS
940: SELECT effective_date
941: FROM pay_payroll_actions
942: WHERE payroll_action_id = pactid;
943:
944: CURSOR csr_input_value_id(p_element_name CHAR,
945: p_value_name CHAR) IS

Line 1305: pay_payroll_actions ppa

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
1309: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1344: pay_payroll_actions ppa

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
1348: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1384: pay_payroll_actions ppa

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
1388: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1584: ,pay_payroll_actions ppa_rev

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
1588: AND paa_src.assignment_id = paa_cur.assignment_id

Line 1753: pay_payroll_actions ppa

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
1757: AND (paa.source_action_id is not null or ppa.action_type in ('I','V'))

Line 2054: pay_payroll_actions pact,

2050: ppf.payroll_name payroll_name,
2051: ppf.period_type period_type,
2052: pact.pay_advice_message payroll_message
2053: FROM pay_payrolls_f ppf,
2054: pay_payroll_actions pact,
2055: hr_soft_coding_keyflex flex,
2056: hr_organization_information org
2057: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2058: AND org.org_information_context = 'IE_ORG_INFORMATION'

Line 2117: pay_payroll_actions pact

2113: pact.effective_date effective_date,
2114: pact.date_earned date_earned,
2115: pact.pay_advice_message payroll_message
2116: FROM pay_payrolls_f ppf,
2117: pay_payroll_actions pact
2118: WHERE pact.payroll_id = ppf.payroll_id
2119: AND pact.effective_date BETWEEN
2120: ppf.effective_start_date AND ppf.effective_end_date
2121: AND pact.payroll_id = p_payroll_id

Line 2343: pay_payroll_actions ppa

2339: END LOOP;
2340:
2341: sqlstr := 'SELECT DISTINCT person_id
2342: FROM per_people_f ppf,
2343: pay_payroll_actions ppa
2344: WHERE ppa.payroll_action_id = :payroll_action_id
2345: AND ppa.business_group_id +0= ppf.business_group_id
2346: ORDER BY ppf.person_id'; */
2347:

Line 2357: pay_payroll_actions ppa

2353: hr_utility.trace('Range Cursor Not using Payroll Restriction');
2354: sqlstr := 'SELECT distinct asg.person_id
2355: FROM per_periods_of_service pos,
2356: per_assignments_f asg,
2357: pay_payroll_actions ppa
2358: WHERE ppa.payroll_action_id = :payroll_action_id
2359: AND pos.person_id = asg.person_id
2360: AND pos.period_of_service_id = asg.period_of_service_id
2361: AND pos.business_group_id = ppa.business_group_id

Line 2371: pay_payroll_actions ppa,

2367: --
2368: hr_utility.trace('Range Cursor using Payroll Restriction');
2369: sqlstr := 'SELECT DISTINCT ppf.person_id
2370: FROM per_people_f ppf,
2371: pay_payroll_actions ppa,
2372: per_assignments_f paaf
2373: WHERE ppa.payroll_action_id = :payroll_action_id
2374: AND ppf.business_group_id +0 = ppa.business_group_id
2375: AND paaf.person_id = ppf.person_id

Line 2455: FROM pay_payroll_actions ppa,

2451: SELECT act.assignment_id assignment_id,
2452: act.assignment_action_id run_action_id,
2453: act1.assignment_action_id prepaid_action_id,
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,

Line 2456: pay_payroll_actions appa,

2452: act.assignment_action_id run_action_id,
2453: act1.assignment_action_id prepaid_action_id,
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,

Line 2457: pay_payroll_actions appa2,

2453: act1.assignment_action_id prepaid_action_id,
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

Line 2485: pay_payroll_actions appa3

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
2489: AND appa3.action_type = 'X'

Line 2506: FROM pay_payroll_actions ppa,

2502: SELECT act.assignment_id assignment_id,
2503: act.assignment_action_id run_action_id,
2504: act1.assignment_action_id prepaid_action_id,
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,

Line 2507: pay_payroll_actions appa,

2503: act.assignment_action_id run_action_id,
2504: act1.assignment_action_id prepaid_action_id,
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,

Line 2508: pay_payroll_actions appa2,

2504: act1.assignment_action_id prepaid_action_id,
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,

Line 2538: pay_payroll_actions appa3

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
2542: AND appa3.action_type = 'X'

Line 2702: pay_payroll_actions paa,

2698: paa.date_earned date_earned,
2699: ptp.time_period_id time_period_id
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

Line 2703: pay_payroll_actions ppaa,

2699: ptp.time_period_id time_period_id
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

Line 2777: pay_payroll_actions ppa

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'))
2781: AND ppa.effective_date <= p_effective_date

Line 2797: pay_payroll_actions ppa

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'))
2801: AND ppa.effective_date between trunc(p_effective_date,'Y') and p_effective_date

Line 2837: pay_payroll_actions ppa

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'))
2841: AND ppa.effective_date between trunc(p_effective_date,'Y') and p_effective_date

Line 3191: pay_payroll_actions pact,

3187: ppf.payroll_name payroll_name,
3188: ppf.period_type period_type,
3189: pact.pay_advice_message payroll_message
3190: FROM pay_payrolls_f ppf,
3191: pay_payroll_actions pact,
3192: hr_soft_coding_keyflex flex,
3193: hr_organization_information org
3194: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
3195: AND org.org_information_context = 'IE_EMPLOYER_INFO'

Line 3264: pay_payroll_actions pact

3260: pact.effective_date effective_date,
3261: pact.date_earned date_earned,
3262: pact.pay_advice_message payroll_message
3263: FROM pay_payrolls_f ppf,
3264: pay_payroll_actions pact
3265: WHERE pact.payroll_id = ppf.payroll_id
3266: AND pact.effective_date BETWEEN
3267: ppf.effective_start_date AND ppf.effective_end_date
3268: AND pact.payroll_id = p_payroll_id