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 752: FROM pay_payroll_actions

748: IS
749:
750: CURSOR csr_archive_effective_date(pactid NUMBER) IS
751: SELECT effective_date
752: FROM pay_payroll_actions
753: WHERE payroll_action_id = pactid;
754:
755: CURSOR csr_input_value_id(p_element_name CHAR,
756: p_value_name CHAR) IS

Line 1084: pay_payroll_actions ppa

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

Line 1123: pay_payroll_actions ppa

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

Line 1163: pay_payroll_actions ppa

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

Line 1363: ,pay_payroll_actions ppa_rev

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

Line 1767: pay_payroll_actions pact,

1763: ppf.payroll_name payroll_name,
1764: ppf.period_type period_type,
1765: pact.pay_advice_message payroll_message
1766: FROM pay_payrolls_f ppf,
1767: pay_payroll_actions pact,
1768: hr_soft_coding_keyflex flex,
1769: hr_organization_information org
1770: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1771: AND org.org_information_context = 'IE_ORG_INFORMATION'

Line 1830: pay_payroll_actions pact

1826: pact.effective_date effective_date,
1827: pact.date_earned date_earned,
1828: pact.pay_advice_message payroll_message
1829: FROM pay_payrolls_f ppf,
1830: pay_payroll_actions pact
1831: WHERE pact.payroll_id = ppf.payroll_id
1832: AND pact.effective_date BETWEEN
1833: ppf.effective_start_date AND ppf.effective_end_date
1834: AND pact.payroll_id = p_payroll_id

Line 2046: pay_payroll_actions ppa

2042: END LOOP;
2043:
2044: sqlstr := 'SELECT DISTINCT person_id
2045: FROM per_people_f ppf,
2046: pay_payroll_actions ppa
2047: WHERE ppa.payroll_action_id = :payroll_action_id
2048: AND ppa.business_group_id +0= ppf.business_group_id
2049: ORDER BY ppf.person_id'; */
2050:

Line 2060: pay_payroll_actions ppa

2056: hr_utility.trace('Range Cursor Not using Payroll Restriction');
2057: sqlstr := 'SELECT distinct asg.person_id
2058: FROM per_periods_of_service pos,
2059: per_assignments_f asg,
2060: pay_payroll_actions ppa
2061: WHERE ppa.payroll_action_id = :payroll_action_id
2062: AND pos.person_id = asg.person_id
2063: AND pos.period_of_service_id = asg.period_of_service_id
2064: AND pos.business_group_id = ppa.business_group_id

Line 2074: pay_payroll_actions ppa,

2070: --
2071: hr_utility.trace('Range Cursor using Payroll Restriction');
2072: sqlstr := 'SELECT DISTINCT ppf.person_id
2073: FROM per_people_f ppf,
2074: pay_payroll_actions ppa,
2075: per_assignments_f paaf
2076: WHERE ppa.payroll_action_id = :payroll_action_id
2077: AND ppf.business_group_id +0 = ppa.business_group_id
2078: AND paaf.person_id = ppf.person_id

Line 2158: FROM pay_payroll_actions ppa,

2154: SELECT act.assignment_id assignment_id,
2155: act.assignment_action_id run_action_id,
2156: act1.assignment_action_id prepaid_action_id,
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,

Line 2159: pay_payroll_actions appa,

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

Line 2160: pay_payroll_actions appa2,

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

Line 2188: pay_payroll_actions appa3

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

Line 2209: FROM pay_payroll_actions ppa,

2205: SELECT act.assignment_id assignment_id,
2206: act.assignment_action_id run_action_id,
2207: act1.assignment_action_id prepaid_action_id,
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,

Line 2210: pay_payroll_actions appa,

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

Line 2211: pay_payroll_actions appa2,

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

Line 2241: pay_payroll_actions appa3

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

Line 2405: pay_payroll_actions paa,

2401: paa.date_earned date_earned,
2402: ptp.time_period_id time_period_id
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

Line 2406: pay_payroll_actions ppaa,

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

Line 2471: pay_payroll_actions ppa

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

Line 2491: pay_payroll_actions ppa

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

Line 2531: pay_payroll_actions ppa

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

Line 2876: pay_payroll_actions pact,

2872: ppf.payroll_name payroll_name,
2873: ppf.period_type period_type,
2874: pact.pay_advice_message payroll_message
2875: FROM pay_payrolls_f ppf,
2876: pay_payroll_actions pact,
2877: hr_soft_coding_keyflex flex,
2878: hr_organization_information org
2879: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
2880: AND org.org_information_context = 'IE_EMPLOYER_INFO'

Line 2949: pay_payroll_actions pact

2945: pact.effective_date effective_date,
2946: pact.date_earned date_earned,
2947: pact.pay_advice_message payroll_message
2948: FROM pay_payrolls_f ppf,
2949: pay_payroll_actions pact
2950: WHERE pact.payroll_id = ppf.payroll_id
2951: AND pact.effective_date BETWEEN
2952: ppf.effective_start_date AND ppf.effective_end_date
2953: AND pact.payroll_id = p_payroll_id