APPS.PAY_IE_PAYE_PKG dependencies on PAY_ALL_PAYROLLS_F

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

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

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

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

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

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

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

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

Line 1116: FROM pay_all_payrolls_f pp

1112: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1113:
1114: Cursor csr_freq(p_payroll_id number,p_effective_date date) IS
1115: SELECT 1
1116: FROM pay_all_payrolls_f pp
1117: WHERE pp.payroll_id = p_payroll_id
1118: AND p_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date
1119: AND period_type IN ('Calendar Month', 'Quarter', 'Bi-Month', 'Semi-Month', 'Semi-Year', 'Year');
1120: