[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.
210: -- This function is to return the assignment status
211: --------------------------------------------------------------------+
212: /*Bug#3662449 function added to check for assignment status*/
213: function check_termination
214: (p_sys_status per_assignment_status_types.per_system_status%TYPE,
215: p_emp_type varchar2)
216: return varchar2
217: is
218: l_status varchar2(10);
414: pay_payroll_actions ppa1,
415: pay_assignment_actions paa,
416: hr_organization_units hou,
417: per_periods_of_service pps
418: -- ,per_assignment_status_types past
419: where ppa.payroll_action_id = c_payroll_action_id
420: and paa.assignment_id = paaf.assignment_id
421: and pap.person_id between c_start_person and c_end_person
422: and pap.person_id = paaf.person_id
617: pay_payroll_actions ppa,
618: pay_payroll_actions ppa1,
619: pay_assignment_actions paa,
620: per_periods_of_service pps
621: -- ,per_assignment_status_types past
622: where ppa.payroll_action_id = c_payroll_action_id
623: and paa.assignment_id = paaf.assignment_id
624: and pap.person_id between c_start_person and c_end_person
625: and pap.person_id = paaf.person_id
811: pay_payroll_actions ppa,
812: pay_payroll_actions ppa1,
813: pay_assignment_actions paa,
814: per_periods_of_service pps
815: -- per_assignment_status_types past
816: where ppa.payroll_action_id = c_payroll_action_id
817: and paa.assignment_id = paaf.assignment_id
818: and pap.person_id between c_start_person and c_end_person
819: and pap.person_id = paaf.person_id
1010: pay_payroll_actions ppa,
1011: pay_payroll_actions ppa1,
1012: pay_assignment_actions paa,
1013: per_periods_of_service pps
1014: -- ,per_assignment_status_types past
1015: where ppa.payroll_action_id = c_payroll_action_id
1016: and paa.assignment_id = paaf.assignment_id
1017: and pap.person_id between c_start_person and c_end_person
1018: and pap.person_id = paaf.person_id
1200: pay_payroll_actions ppa,
1201: pay_payroll_actions ppa1,
1202: pay_assignment_actions paa,
1203: per_periods_of_service pps
1204: -- ,per_assignment_status_types past
1205: where ppa.payroll_action_id = c_payroll_action_id
1206: and paa.assignment_id = paaf.assignment_id
1207: and pap.person_id between c_start_person and c_end_person
1208: and pap.person_id = paaf.person_id
2768: per_grades_tl pgr, /* Bug 3953702*/
2769: per_periods_of_service pps,
2770: per_pay_bases ppb,
2771: per_pay_proposals pro,
2772: per_assignment_status_types past,
2773: hr_soft_coding_keyflex hsc, /*Bug 4040688*/
2774: hr_all_organization_units hou, /*Bug 3953706 */
2775: hr_all_organization_units hou1 /*Bug 4132525*/
2776: -- pay_payrolls_f papf /*Bug 4132525, Bug 4688872*/