[Home] [Help]
76: ** 05-May-2008 knadhan 6929566 Replaced p_effective_date with new parameter p_cert_date,
77: -------------------------------------------------------------------------------
78: */
79: g_package varchar2(33) := 'pay_ie_paye.';
80: g_old_payroll_id per_all_assignments_f.payroll_id%TYPE; --added for update_paye_change_freq
81: /* Added cursor for Bug 3030621 */
82: cursor g_absence_dates (c_element_entry_id number) is
83: SELECT pev.SCREEN_ENTRY_VALUE
84: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet,pay_element_entry_values_f pev,
161:
162: -- Cursor to check whether multiple assignment has a different tax basis
163: CURSOR chk_multi_asgn_tax_basis IS
164: SELECT 1
165: FROM per_all_assignments_f paaf
166: ,per_time_periods ptp
167: ,pay_ie_paye_details_f pipd
168: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
169: AND paaf.assignment_id <> p_assignment_id
164: SELECT 1
165: FROM per_all_assignments_f paaf
166: ,per_time_periods ptp
167: ,pay_ie_paye_details_f pipd
168: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
169: AND paaf.assignment_id <> p_assignment_id
170: AND pipd.assignment_id(+) = paaf.assignment_id
171: AND nvl(pipd.tax_basis,'X') <> 'IE_EXCLUDE'
172: AND p_date_earned BETWEEN ptp.start_date and ptp.end_date
211:
212: -- Cursor to check whether multiple assignment has a different tax basis
213: CURSOR chk_multi_asgn_tax_basis IS
214: SELECT 1
215: FROM per_all_assignments_f paaf
216: ,per_time_periods ptp
217: ,pay_ie_paye_details_f pipd
218: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
219: AND paaf.assignment_id <> p_assignment_id
214: SELECT 1
215: FROM per_all_assignments_f paaf
216: ,per_time_periods ptp
217: ,pay_ie_paye_details_f pipd
218: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
219: AND paaf.assignment_id <> p_assignment_id
220: AND pipd.assignment_id(+) = paaf.assignment_id
221: AND nvl(pipd.tax_basis,'X') = 'IE_EXCLUDE'
222: AND p_date_earned BETWEEN ptp.start_date and ptp.end_date
607:
608: Cursor csr_pps_number IS
609: SELECT nvl(pap.national_identifier, 'X')
610: FROM per_all_people_f pap
611: ,per_all_assignments_f paa
612: ,pay_payroll_actions ppa
613: WHERE ppa.payroll_action_id = p_payroll_action_id
614: and paa.assignment_id = p_assignment_id
615: and ppa.effective_date between paa.effective_start_date and paa.effective_end_date
665: --
666: l_valid varchar2(10);
667: cursor csr_find_match is
668: select 'TRUE'
669: from per_all_assignments_f asg,
670: per_work_incidents pwi,
671: hr_lookups hl
672: where p_date_earned between asg.effective_start_date
673: and asg.effective_end_date and
773: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
774: --
775: CURSOR get_pay_frequency_csr IS
776: SELECT pp.period_type
777: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
778: WHERE pa.assignment_id = p_assignment_id
779: AND ses.session_id = userenv('SESSIONID')
780: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
781: AND pp.payroll_id = pa.payroll_id
835: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
836: --
837: CURSOR get_pay_frequency_csr IS
838: SELECT pp.period_type
839: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
840: WHERE pa.assignment_id = p_assignment_id
841: AND ses.session_id = userenv('SESSIONID')
842: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
843: AND pp.payroll_id = pa.payroll_id
902: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
903: --
904: CURSOR get_pay_frequency_csr IS
905: SELECT pp.period_type
906: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
907: WHERE pa.assignment_id = p_assignment_id
908: AND ses.session_id = userenv('SESSIONID')
909: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
910: AND pp.payroll_id = pa.payroll_id
965: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
966: --
967: CURSOR get_pay_frequency_csr IS
968: SELECT pp.period_type
969: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
970: WHERE pa.assignment_id = p_assignment_id
971: AND ses.session_id = userenv('SESSIONID')
972: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
973: AND pp.payroll_id = pa.payroll_id
1099:
1100:
1101: Cursor csr_get_assg(p_assignment_id in number,p_effective_date date) is
1102: SELECT payroll_id ,effective_start_date
1103: FROM per_all_assignments_f paa
1104: WHERE paa.assignment_id=p_assignment_id
1105: AND p_effective_date between paa.effective_start_date
1106: and paa.effective_end_date;
1107: