[Home] [Help]
51: *** name. Sorting of records in reports to be done on basis of Org. names, Payroll names, Legal Employer names.
52: *** 25-JAN-05 abhkumar 1.27 4142159 Introduced Parameter P_DELETE_ACTIONS.
53: *** 08-FEB-05 ksingla 1.28 4161540 Modified cursors csr_assignment_org_period , csr_assignment_legal_period,
54: *** csr_assignment_payroll_period ,csr_assignment_period ,csr_assignment_default_period.
55: *** Removed join for per_assignment_status_types.
56: *** 09-FEB-05 ksingla 1.29 4161540 Modified cursors csr_assignment_org_period , csr_assignment_legal_period,
57: *** csr_assignment_payroll_period ,csr_assignment_period ,csr_assignment_default_period.
58: *** Modified the subquery for the check of termination in the same way as in pay_au_payment_summary .
59: *** 11-FEB-05 abhkumar 1.30 4132149 Modified initialisation_code to initialise the global variables for legislative parameters.
138: -- This function is to return the assignment status
139: --------------------------------------------------------------------+
140: /*Bug#3662449 function added to check for assignment status*/
141: function check_termination
142: (p_sys_status per_assignment_status_types.per_system_status%TYPE,
143: p_emp_type varchar2)
144: return varchar2
145: is
146: l_status varchar2(10);
342: pay_payroll_actions ppa1,
343: pay_assignment_actions paa,
344: hr_organization_units hou,
345: per_periods_of_service pps
346: -- ,per_assignment_status_types past
347: where ppa.payroll_action_id = c_payroll_action_id
348: and paa.assignment_id = paaf.assignment_id
349: and pap.person_id between c_start_person and c_end_person
350: and pap.person_id = paaf.person_id
441: pay_payroll_actions ppa,
442: pay_payroll_actions ppa1,
443: pay_assignment_actions paa,
444: per_periods_of_service pps
445: -- ,per_assignment_status_types past
446: where ppa.payroll_action_id = c_payroll_action_id
447: and paa.assignment_id = paaf.assignment_id
448: and pap.person_id between c_start_person and c_end_person
449: and pap.person_id = paaf.person_id
536: pay_payroll_actions ppa,
537: pay_payroll_actions ppa1,
538: pay_assignment_actions paa,
539: per_periods_of_service pps
540: -- per_assignment_status_types past
541: where ppa.payroll_action_id = c_payroll_action_id
542: and paa.assignment_id = paaf.assignment_id
543: and pap.person_id between c_start_person and c_end_person
544: and pap.person_id = paaf.person_id
631: pay_payroll_actions ppa,
632: pay_payroll_actions ppa1,
633: pay_assignment_actions paa,
634: per_periods_of_service pps
635: -- ,per_assignment_status_types past
636: where ppa.payroll_action_id = c_payroll_action_id
637: and paa.assignment_id = paaf.assignment_id
638: and pap.person_id between c_start_person and c_end_person
639: and pap.person_id = paaf.person_id
723: pay_payroll_actions ppa,
724: pay_payroll_actions ppa1,
725: pay_assignment_actions paa,
726: per_periods_of_service pps
727: -- ,per_assignment_status_types past
728: where ppa.payroll_action_id = c_payroll_action_id
729: and paa.assignment_id = paaf.assignment_id
730: and pap.person_id between c_start_person and c_end_person
731: and pap.person_id = paaf.person_id
1569: per_grades_tl pgr, /* Bug 3953702*/
1570: per_periods_of_service pps,
1571: per_pay_bases ppb,
1572: per_pay_proposals pro,
1573: per_assignment_status_types past,
1574: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
1575: hr_organization_units hou, /*Bug 3953706 */
1576: hr_organization_units hou1 /*Bug 4132525*/
1577: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688872*/