eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_PAYE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 90: g_old_payroll_id per_all_assignments_f.payroll_id%TYPE; --added for update_paye_change_freq

86: ** 23-Nov-2011 smeduri 13359545 added func get_usc_details
87: -------------------------------------------------------------------------------
88: */
89: g_package varchar2(33) := 'pay_ie_paye.';
90: g_old_payroll_id per_all_assignments_f.payroll_id%TYPE; --added for update_paye_change_freq
91: /* Added cursor for Bug 3030621 */
92: cursor g_absence_dates (c_element_entry_id number) is
93: SELECT pev.SCREEN_ENTRY_VALUE
94: FROM pay_element_entries_f pee, pay_element_links_f pel, pay_element_types_f pet,pay_element_entry_values_f pev,

Line 175: FROM per_all_assignments_f paaf

171:
172: -- Cursor to check whether multiple assignment has a different tax basis
173: CURSOR chk_multi_asgn_tax_basis IS
174: SELECT 1
175: FROM per_all_assignments_f paaf
176: ,per_time_periods ptp
177: ,pay_ie_paye_details_f pipd
178: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
179: AND paaf.assignment_id <> p_assignment_id

Line 178: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )

174: SELECT 1
175: FROM per_all_assignments_f paaf
176: ,per_time_periods ptp
177: ,pay_ie_paye_details_f pipd
178: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
179: AND paaf.assignment_id <> p_assignment_id
180: AND pipd.assignment_id(+) = paaf.assignment_id
181: AND nvl(pipd.tax_basis,'X') <> 'IE_EXCLUDE'
182: AND p_date_earned BETWEEN ptp.start_date and ptp.end_date

Line 225: FROM per_all_assignments_f paaf

221:
222: -- Cursor to check whether multiple assignment has a different tax basis
223: CURSOR chk_multi_asgn_tax_basis IS
224: SELECT 1
225: FROM per_all_assignments_f paaf
226: ,per_time_periods ptp
227: ,pay_ie_paye_details_f pipd
228: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
229: AND paaf.assignment_id <> p_assignment_id

Line 228: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )

224: SELECT 1
225: FROM per_all_assignments_f paaf
226: ,per_time_periods ptp
227: ,pay_ie_paye_details_f pipd
228: WHERE paaf.person_id = ( SELECT distinct person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id )
229: AND paaf.assignment_id <> p_assignment_id
230: AND pipd.assignment_id(+) = paaf.assignment_id
231: AND nvl(pipd.tax_basis,'X') = 'IE_EXCLUDE'
232: AND p_date_earned BETWEEN ptp.start_date and ptp.end_date

Line 743: ,per_all_assignments_f paa

739:
740: Cursor csr_pps_number IS
741: SELECT nvl(pap.national_identifier, 'X')
742: FROM per_all_people_f pap
743: ,per_all_assignments_f paa
744: ,pay_payroll_actions ppa
745: WHERE ppa.payroll_action_id = p_payroll_action_id
746: and paa.assignment_id = p_assignment_id
747: and ppa.effective_date between paa.effective_start_date and paa.effective_end_date

Line 801: from per_all_assignments_f asg,

797: --
798: l_valid varchar2(10);
799: cursor csr_find_match is
800: select 'TRUE'
801: from per_all_assignments_f asg,
802: per_work_incidents pwi,
803: hr_lookups hl
804: where p_date_earned between asg.effective_start_date
805: and asg.effective_end_date and

Line 909: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

905: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
906: --
907: CURSOR get_pay_frequency_csr IS
908: SELECT pp.period_type
909: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
910: WHERE pa.assignment_id = p_assignment_id
911: AND ses.session_id = userenv('SESSIONID')
912: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
913: AND pp.payroll_id = pa.payroll_id

Line 971: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

967: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
968: --
969: CURSOR get_pay_frequency_csr IS
970: SELECT pp.period_type
971: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
972: WHERE pa.assignment_id = p_assignment_id
973: AND ses.session_id = userenv('SESSIONID')
974: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
975: AND pp.payroll_id = pa.payroll_id

Line 1038: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

1034: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
1035: --
1036: CURSOR get_pay_frequency_csr IS
1037: SELECT pp.period_type
1038: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
1039: WHERE pa.assignment_id = p_assignment_id
1040: AND ses.session_id = userenv('SESSIONID')
1041: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
1042: AND pp.payroll_id = pa.payroll_id

Line 1101: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses

1097: AND ses.effective_date BETWEEN effective_start_date AND effective_end_date;
1098: --
1099: CURSOR get_pay_frequency_csr IS
1100: SELECT pp.period_type
1101: FROM pay_all_payrolls_f pp, per_all_assignments_f pa,fnd_sessions ses
1102: WHERE pa.assignment_id = p_assignment_id
1103: AND ses.session_id = userenv('SESSIONID')
1104: AND ses.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date
1105: AND pp.payroll_id = pa.payroll_id

Line 1274: FROM per_all_assignments_f paa

1270:
1271:
1272: Cursor csr_get_assg(p_assignment_id in number,p_effective_date date) is
1273: SELECT payroll_id ,effective_start_date
1274: FROM per_all_assignments_f paa
1275: WHERE paa.assignment_id=p_assignment_id
1276: AND p_effective_date between paa.effective_start_date
1277: and paa.effective_end_date;
1278:

Line 2093: ,per_all_assignments_f paf

2089: --
2090: CURSOR get_dob IS
2091: SELECT date_of_birth,per.last_name,paf.assignment_number
2092: FROM per_all_people_f per
2093: ,per_all_assignments_f paf
2094: WHERE per.person_id = paf.person_id
2095: AND paf.assignment_id = p_assignment_id
2096: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date
2097: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 2158: ,per_all_assignments_f paf

2154: --
2155: CURSOR get_dob IS
2156: SELECT date_of_birth,per.last_name,paf.assignment_number
2157: FROM per_all_people_f per
2158: ,per_all_assignments_f paf
2159: WHERE per.person_id = paf.person_id
2160: AND paf.assignment_id = p_assignment_id
2161: AND l_date_paid BETWEEN per.effective_start_date AND per.effective_end_date
2162: AND l_date_paid BETWEEN paf.effective_start_date AND paf.effective_end_date;