[Home] [Help]
87: ) + length(p_token)
88: )
89: ),
90: business_group_id
91: from pay_payroll_actions
92: where payroll_action_id = p_pact_id;
93:
94: l_business_group_id varchar2(20);
95: l_token_value varchar2(50);
408: pay_element_classifications pec,
409: pay_assignment_actions paa, -- Assignment Action of Prepayments
410: pay_assignment_actions rpaa, -- Assignment Action of Run
411: pay_action_interlocks pai,
412: pay_payroll_actions ppa -- Payroll Action of Prepayments
413: where pet.element_type_id = prr.element_type_id
414: and piv.element_type_id = pet.element_type_id
415: and piv.name = 'Pay Value'
416: and pet.classification_id = pec.classification_id
1157: procedure archinit(p_payroll_action_id in number) is -- Payroll Action of the Archiver
1158:
1159: cursor csr_archive_effective_date(pactid number) is
1160: select effective_date
1161: from pay_payroll_actions
1162: where payroll_action_id = pactid;
1163:
1164: cursor csr_input_value_id
1165: (
1184: ) is
1185: select pact.payroll_action_id payroll_action_id,
1186: pact.effective_date effective_date
1187: from pay_payrolls_f ppf,
1188: pay_payroll_actions pact -- Payroll Action of Prepayments
1189: where pact.payroll_id = ppf.payroll_id
1190: and pact.effective_date between ppf.effective_start_date and ppf.effective_end_date
1191: and pact.payroll_id = nvl(p_payroll_id, pact.payroll_id)
1192: and pact.consolidation_set_id = p_consolidation_id
1267: p_token_value => l_bg_id
1268: );
1269:
1270: --Added for Bug 7519419
1271: update pay_payroll_actions
1272: set payroll_id = l_payroll_id, consolidation_set_id = l_consolidation_set
1273: where payroll_action_id=p_payroll_action_id;
1274:
1275: hr_utility.set_location('Step ' || l_proc, 20);
1925: ppf.payroll_name payroll_name,
1926: ppf.period_type period_type,
1927: pact.pay_advice_message payroll_message
1928: from pay_payrolls_f ppf,
1929: pay_payroll_actions pact -- Payroll Action of Prepayments
1930: where pact.payroll_id = ppf.payroll_id
1931: and pact.effective_date between ppf.effective_start_date and ppf.effective_end_date
1932: and pact.payroll_id = nvl(p_payroll_id, pact.payroll_id)
1933: and pact.consolidation_set_id = p_consolidation_id
1956: pact.effective_date effective_date,
1957: pact.date_earned date_earned,
1958: pact.pay_advice_message payroll_message
1959: from pay_payrolls_f ppf,
1960: pay_payroll_actions pact -- Payroll Action of Run
1961: where pact.payroll_id = ppf.payroll_id
1962: and pact.effective_date between ppf.effective_start_date and ppf.effective_end_date
1963: and pact.payroll_id = p_payroll_id
1964: and pact.effective_date between p_start_date and p_end_date
2225: -- Populate the sqlstr to specify person_id's to process
2226: -- 3221746 modified business_group_id join condition
2227: sqlstr := 'select distinct person_id
2228: from per_people_f ppf,
2229: pay_payroll_actions ppa
2230: where ppa.payroll_action_id = :payroll_action_id
2231: and ppf.business_group_id = ppa.business_group_id
2232: order by ppf.person_id';
2233:
2264: ) is
2265: select paa_run.assignment_id assignment_id,
2266: paa_run.assignment_action_id run_action_id,
2267: paa_pre.assignment_action_id prepaid_action_id
2268: from pay_payroll_actions ppa_pre, -- Payroll Action of Prepayment
2269: pay_assignment_actions paa_pre, -- Assignment Action of Prepayment
2270: pay_action_interlocks pai,
2271: per_all_assignments_f paaf,
2272: pay_assignment_actions paa_run, -- Assignment Action of Run
2269: pay_assignment_actions paa_pre, -- Assignment Action of Prepayment
2270: pay_action_interlocks pai,
2271: per_all_assignments_f paaf,
2272: pay_assignment_actions paa_run, -- Assignment Action of Run
2273: pay_payroll_actions ppa_run, -- Payroll Action of Run
2274: pay_payroll_actions ppa_arch -- Payroll Action of Archiver
2275: where ppa_arch.payroll_action_id = p_pact_id
2276: and ppa_run.action_type in ('R', 'Q') -- Payroll Run or Quickpay Run
2277: and (ppa_run.payroll_id = p_payroll_id or p_payroll_id is null)
2270: pay_action_interlocks pai,
2271: per_all_assignments_f paaf,
2272: pay_assignment_actions paa_run, -- Assignment Action of Run
2273: pay_payroll_actions ppa_run, -- Payroll Action of Run
2274: pay_payroll_actions ppa_arch -- Payroll Action of Archiver
2275: where ppa_arch.payroll_action_id = p_pact_id
2276: and ppa_run.action_type in ('R', 'Q') -- Payroll Run or Quickpay Run
2277: and (ppa_run.payroll_id = p_payroll_id or p_payroll_id is null)
2278: and ppa_run.effective_date between ppa_arch.start_date and ppa_arch.effective_date
2294: (
2295: select /*+ ORDERED */ NULL
2296: from pay_action_interlocks pai2,
2297: pay_assignment_actions paa_arch2, -- Assignment Action of Archiver
2298: pay_payroll_actions ppa_arch2 -- Payroll Action of Archiver
2299: where pai2.locked_action_id = paa_run.assignment_action_id
2300: and paa_arch2.assignment_action_id = pai2.locking_action_id
2301: and paa_arch2.payroll_action_id = ppa_arch2.payroll_action_id
2302: and ppa_arch2.action_type = 'X'
2446: paa.date_earned date_earned, -- Date Earned of Run
2447: paa.time_period_id time_period_id -- Time Period Id of Run
2448: from pay_action_interlocks pre, -- Lock of Archiver on Prepayment
2449: pay_action_interlocks pay, -- Lock of Prepayment on Run
2450: pay_payroll_actions paa, -- Payroll Action of Run
2451: pay_payroll_actions ppaa, -- Payroll Action of Archiver
2452: pay_assignment_actions assact, -- Assignment Action of Run
2453: pay_assignment_actions passact -- Assignment Action of Archiver
2454: where pre.locked_action_id = pay.locking_action_id
2447: paa.time_period_id time_period_id -- Time Period Id of Run
2448: from pay_action_interlocks pre, -- Lock of Archiver on Prepayment
2449: pay_action_interlocks pay, -- Lock of Prepayment on Run
2450: pay_payroll_actions paa, -- Payroll Action of Run
2451: pay_payroll_actions ppaa, -- Payroll Action of Archiver
2452: pay_assignment_actions assact, -- Assignment Action of Run
2453: pay_assignment_actions passact -- Assignment Action of Archiver
2454: where pre.locked_action_id = pay.locking_action_id
2455: and pre.locking_action_id = p_locking_action_id -- Assignment Action of Archiver
2853: ppf.payroll_name payroll_name,
2854: ppf.period_type period_type,
2855: pact.pay_advice_message payroll_message
2856: from pay_payrolls_f ppf,
2857: pay_payroll_actions pact -- Payroll Action of Prepayments
2858: where pact.payroll_id = ppf.payroll_id
2859: and pact.effective_date between ppf.effective_start_date and ppf.effective_end_date
2860: and pact.payroll_id = nvl(p_payroll_id, pact.payroll_id)
2861: and pact.consolidation_set_id = p_consolidation_id
2873:
2874:
2875: cursor c_effective_date (cp_payroll_action_id in number) is
2876: select effective_date
2877: from pay_payroll_actions
2878: where payroll_action_id = cp_payroll_action_id;
2879:
2880: l_effective_date DATE;
2881: lv_error_message VARCHAR2(200);