[Home] [Help]
100: ) + length(p_token)
101: )
102: ),
103: business_group_id
104: from pay_payroll_actions
105: where payroll_action_id = p_pact_id;
106:
107: l_business_group_id number;
108: l_proc varchar2(50) := g_package || 'get_parameters';
142: ) return varchar2 is
143:
144: start_ptr number;
145: end_ptr number;
146: token_val pay_payroll_actions.legislative_parameters%type;
147: par_value pay_payroll_actions.legislative_parameters%type;
148:
149: begin
150:
143:
144: start_ptr number;
145: end_ptr number;
146: token_val pay_payroll_actions.legislative_parameters%type;
147: par_value pay_payroll_actions.legislative_parameters%type;
148:
149: begin
150:
151: token_val := name || '=';
202: p_token_value => l_payroll_id
203: );
204:
205: -- Update the payroll_id column on the Payroll_Action record.
206: update pay_payroll_actions
207: set payroll_id = l_payroll_id
208: where payroll_action_id = pactid;
209: */
210: -- Retrieve the LEGAL_ENTITY_ID from legislative parameters from the payroll action
221: sqlstr :=
222: 'select distinct ass.person_id
223: from per_assignments_f ass,
224: pay_payrolls_f ppf,
225: pay_payroll_actions ppa
226: where ppa.payroll_action_id = :payroll_action_id
227: and ass.business_group_id = ppa.business_group_id
228: and ass.assignment_type = ''E''
229: and ppf.payroll_id = ass.payroll_id
233: sqlstr :=
234: 'select distinct paf.person_id
235: from per_assignments_f paf,
236: pay_payrolls_f ppf,
237: pay_payroll_actions ppa ,
238: per_assignment_extra_info aei
239: where ppa.payroll_action_id = :payroll_action_id
240: and paf.business_group_id = ppa.business_group_id
241: and paf.assignment_type = ''E''
271: ) is
272:
273: cursor csr_archive_effective_date(pactid number) is
274: select effective_date
275: from pay_payroll_actions
276: where payroll_action_id = pactid;
277:
278: -- Bug 16174886
279: -- payroll name no longer required
417: select ppf.person_id
418: , paa.assignment_id
419: from per_all_people_f ppf
420: , per_all_assignments_f paa
421: , pay_payroll_actions ppa
422: , per_periods_of_service pps
423: , per_assignment_extra_info aei
424: where ppf.person_id between p_stperson and p_endperson
425: and paa.person_id = ppf.person_id
673: select ppa.payroll_action_id
674: , ppa.payroll_id
675: , ptp.end_date
676: from pay_assignment_actions paa,
677: pay_payroll_actions ppa,
678: per_time_periods ptp
679: where paa.assignment_id = p_assignment_id
680: and paa.payroll_action_id = ppa.payroll_action_id
681: and ppa.action_type IN ('R', 'Q', 'V', 'B', 'I')
684: and ppa.date_earned between ptp.start_date and ptp.end_date
685: and ptp.pay_advice_date between trunc(l_effective_date,'Month') and l_effective_date
686: and paa.action_sequence = (select max(paa1.action_sequence)
687: from pay_assignment_actions paa1,
688: pay_payroll_actions ppa1,
689: per_time_periods ptp1
690: where paa1.assignment_id = p_assignment_id
691: and paa1.payroll_action_id = ppa1.payroll_action_id
692: and ppa1.action_type IN ('R', 'Q', 'V', 'B', 'I')
720: from per_time_periods ptp
721: where ptp.pay_advice_date =
722: (select tperiod.pay_advice_date
723: from per_time_periods tperiod,
724: pay_payroll_actions paction
725: where paction.payroll_action_id = p_payroll_action_id
726: and tperiod.time_period_id = paction.time_period_id
727: )
728: and ptp.end_date <=
727: )
728: and ptp.end_date <=
729: (select tperiod.end_date
730: from per_time_periods tperiod,
731: pay_payroll_actions paction
732: where paction.payroll_action_id = p_payroll_action_id
733: and tperiod.time_period_id = paction.time_period_id
734: )
735: and ptp.payroll_id = p_payroll_id;
742: from per_time_periods PTP
743: where ptp.prd_information1 =
744: (select tperiod.prd_information1
745: from per_time_periods tperiod,
746: pay_payroll_actions paction
747: where paction.payroll_action_id = p_payroll_action_id
748: and tperiod.time_period_id = paction.time_period_id)
749: and ptp.payroll_id = p_payroll_id;
750:
761:
762: --Retrive the Tax Status from Run results
763: cursor csr_tax_status (p_payroll_action_id number ) is
764: select prrv.result_value
765: from pay_payroll_actions ppa
766: , pay_assignment_actions paa
767: , pay_element_types_f pet
768: , pay_input_values_f piv
769: , pay_run_results prr
818: p_payroll_id number)
819: is
820: select paa.assignment_action_id assignment_action_id
821: from pay_assignment_actions paa,
822: pay_payroll_actions ppa,
823: per_time_periods ptp
824: where paa.assignment_id = p_assignment_id
825: and paa.action_status IN ('C','S')
826: and paa.payroll_action_id = ppa.payroll_action_id
955:
956: --get the Archive Effective Date
957: select ppa.payroll_action_id
958: into l_pactid_archive
959: from pay_payroll_actions ppa,
960: pay_assignment_actions paa
961: where paa.payroll_action_id = ppa.payroll_action_id
962: and paa.assignment_action_id = p_assactid;
963:
1435: cursor csr_distinct_payroll_names_rec is
1436: select distinct pai.action_information18 payroll_id,
1437: ppf.payroll_name payroll_name,
1438: pai.effective_date effective_date
1439: from pay_payroll_actions ppa
1440: , pay_assignment_actions paa
1441: , pay_action_information pai
1442: , pay_all_payrolls_f ppf
1443: where ppa.payroll_action_id = pactid