[Home] [Help]
580: end ;
581: end if; -- end of l_asg_set_id is not null
582:
583: if asg_include = TRUE then
584: select pay_assignment_actions_s.nextval
585: into lockingactid
586: from dual;
587:
588: -- Insert assignment into pay_assignment_actions
584: select pay_assignment_actions_s.nextval
585: into lockingactid
586: from dual;
587:
588: -- Insert assignment into pay_assignment_actions
589: hr_nonrun_asact.insact
590: (
591: lockingactid,
592: asgrec.assignment_id,
625: ,a.assignment_number
626: ,a.payroll_id
627: from per_all_people_f p
628: , per_all_assignments_f a
629: , pay_assignment_actions paa
630: where paa.assignment_action_id = p_assactid
631: and a.assignment_id = paa.assignment_id
632: and p.person_id = a.person_id
633: and l_eff_date between p.effective_start_date and p.effective_end_date
672: l_effective_date date) is
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
683: and ptp.payroll_id = ppa.payroll_id
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
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
770: , pay_run_result_values prrv
817: p_month_end date,
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')
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:
964: -- Retrieve the Calendar Month from legislative parameters from the payroll action
985: hr_utility.set_location('csr_asg_details not found',10);
986: select max(effective_end_date)
987: into l_asg_end_date
988: from per_all_assignments_f paf,
989: pay_assignment_actions paa
990: where effective_end_date <= l_month_end
991: and paa.assignment_id = paf.assignment_id
992: and paa.assignment_action_id = p_assactid;
993:
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
1444: and ppa.action_status = 'C'
1623: action_information14 raise_warning,
1624: action_information15 asg_terminated,
1625: action_information16 assignment_no
1626: from pay_action_information pai
1627: , pay_assignment_actions paa
1628: where paa.payroll_action_id = p_archive_pact
1629: and pai.action_context_id = paa.assignment_action_id
1630: and pai.action_context_type = 'AAP'
1631: and pai.action_information_category = 'ZA EMP201 ASSIGNMENT DETAILS'