APPS.PAY_IE_PAYE_PKG dependencies on PAY_ALL_PAYROLLS_F

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 1287: FROM pay_all_payrolls_f pp

1283: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1284:
1285: Cursor csr_freq(p_payroll_id number,p_effective_date date) IS
1286: SELECT 1
1287: FROM pay_all_payrolls_f pp
1288: WHERE pp.payroll_id = p_payroll_id
1289: AND p_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date
1290: AND period_type IN ('Calendar Month', 'Quarter', 'Bi-Month', 'Semi-Month', 'Semi-Year', 'Year');
1291: