[Home] [Help]
86: ) + length(p_token)
87: )
88: ),
89: business_group_id
90: from pay_payroll_actions
91: where payroll_action_id = p_pact_id;
92:
93: l_business_group_id varchar2(20);
94: l_token_value varchar2(50);
397: pay_element_classifications pec,
398: pay_assignment_actions paa, -- Assignment Action of Prepayments
399: pay_assignment_actions rpaa, -- Assignment Action of Run
400: pay_action_interlocks pai,
401: pay_payroll_actions ppa -- Payroll Action of Prepayments
402: where pet.element_type_id = prr.element_type_id
403: and piv.element_type_id = pet.element_type_id
404: and piv.name = 'Pay Value'
405: and pet.classification_id = pec.classification_id
1027: procedure archinit(p_payroll_action_id in number) is -- Payroll Action of the Archiver
1028:
1029: cursor csr_archive_effective_date(pactid number) is
1030: select effective_date
1031: from pay_payroll_actions
1032: where payroll_action_id = pactid;
1033:
1034: cursor csr_input_value_id
1035: (
1054: ) is
1055: select pact.payroll_action_id payroll_action_id,
1056: pact.effective_date effective_date
1057: from pay_payrolls_f ppf,
1058: pay_payroll_actions pact -- Payroll Action of Prepayments
1059: where pact.payroll_id = ppf.payroll_id
1060: and pact.effective_date between ppf.effective_start_date and ppf.effective_end_date
1061: and pact.payroll_id = nvl(p_payroll_id, pact.payroll_id)
1062: and pact.consolidation_set_id = p_consolidation_id
1671: ppf.payroll_name payroll_name,
1672: ppf.period_type period_type,
1673: pact.pay_advice_message payroll_message
1674: from pay_payrolls_f ppf,
1675: pay_payroll_actions pact -- Payroll Action of Prepayments
1676: where pact.payroll_id = ppf.payroll_id
1677: and pact.effective_date between ppf.effective_start_date and ppf.effective_end_date
1678: and pact.payroll_id = nvl(p_payroll_id, pact.payroll_id)
1679: and pact.consolidation_set_id = p_consolidation_id
1702: pact.effective_date effective_date,
1703: pact.date_earned date_earned,
1704: pact.pay_advice_message payroll_message
1705: from pay_payrolls_f ppf,
1706: pay_payroll_actions pact -- Payroll Action of Run
1707: where pact.payroll_id = ppf.payroll_id
1708: and pact.effective_date between ppf.effective_start_date and ppf.effective_end_date
1709: and pact.payroll_id = p_payroll_id
1710: and pact.effective_date between p_start_date and p_end_date
1965: -- Populate the sqlstr to specify person_id's to process
1966: -- 3221746 modified business_group_id join condition
1967: sqlstr := 'select distinct person_id
1968: from per_people_f ppf,
1969: pay_payroll_actions ppa
1970: where ppa.payroll_action_id = :payroll_action_id
1971: and ppf.business_group_id = ppa.business_group_id
1972: order by ppf.person_id';
1973:
2004: ) is
2005: select paa_run.assignment_id assignment_id,
2006: paa_run.assignment_action_id run_action_id,
2007: paa_pre.assignment_action_id prepaid_action_id
2008: from pay_payroll_actions ppa_pre, -- Payroll Action of Prepayment
2009: pay_assignment_actions paa_pre, -- Assignment Action of Prepayment
2010: pay_action_interlocks pai,
2011: per_all_assignments_f paaf,
2012: pay_assignment_actions paa_run, -- Assignment Action of Run
2009: pay_assignment_actions paa_pre, -- Assignment Action of Prepayment
2010: pay_action_interlocks pai,
2011: per_all_assignments_f paaf,
2012: pay_assignment_actions paa_run, -- Assignment Action of Run
2013: pay_payroll_actions ppa_run, -- Payroll Action of Run
2014: pay_payroll_actions ppa_arch -- Payroll Action of Archiver
2015: where ppa_arch.payroll_action_id = p_pact_id
2016: and ppa_run.action_type in ('R', 'Q') -- Payroll Run or Quickpay Run
2017: and (ppa_run.payroll_id = p_payroll_id or p_payroll_id is null)
2010: pay_action_interlocks pai,
2011: per_all_assignments_f paaf,
2012: pay_assignment_actions paa_run, -- Assignment Action of Run
2013: pay_payroll_actions ppa_run, -- Payroll Action of Run
2014: pay_payroll_actions ppa_arch -- Payroll Action of Archiver
2015: where ppa_arch.payroll_action_id = p_pact_id
2016: and ppa_run.action_type in ('R', 'Q') -- Payroll Run or Quickpay Run
2017: and (ppa_run.payroll_id = p_payroll_id or p_payroll_id is null)
2018: and ppa_run.effective_date between ppa_arch.start_date and ppa_arch.effective_date
2034: (
2035: select /*+ ORDERED */ NULL
2036: from pay_action_interlocks pai2,
2037: pay_assignment_actions paa_arch2, -- Assignment Action of Archiver
2038: pay_payroll_actions ppa_arch2 -- Payroll Action of Archiver
2039: where pai2.locked_action_id = paa_run.assignment_action_id
2040: and paa_arch2.assignment_action_id = pai2.locking_action_id
2041: and paa_arch2.payroll_action_id = ppa_arch2.payroll_action_id
2042: and ppa_arch2.action_type = 'X'
2186: paa.date_earned date_earned, -- Date Earned of Run
2187: paa.time_period_id time_period_id -- Time Period Id of Run
2188: from pay_action_interlocks pre, -- Lock of Archiver on Prepayment
2189: pay_action_interlocks pay, -- Lock of Prepayment on Run
2190: pay_payroll_actions paa, -- Payroll Action of Run
2191: pay_payroll_actions ppaa, -- Payroll Action of Archiver
2192: pay_assignment_actions assact, -- Assignment Action of Run
2193: pay_assignment_actions passact -- Assignment Action of Archiver
2194: where pre.locked_action_id = pay.locking_action_id
2187: paa.time_period_id time_period_id -- Time Period Id of Run
2188: from pay_action_interlocks pre, -- Lock of Archiver on Prepayment
2189: pay_action_interlocks pay, -- Lock of Prepayment on Run
2190: pay_payroll_actions paa, -- Payroll Action of Run
2191: pay_payroll_actions ppaa, -- Payroll Action of Archiver
2192: pay_assignment_actions assact, -- Assignment Action of Run
2193: pay_assignment_actions passact -- Assignment Action of Archiver
2194: where pre.locked_action_id = pay.locking_action_id
2195: and pre.locking_action_id = p_locking_action_id -- Assignment Action of Archiver