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 PAY_ALL_PAYROLLS

Line 675: pay_all_payrolls pap,

671:
672: cursor c_payroll_details is select ptp.period_num
673: ,ptp.period_type
674: from per_time_periods ptp,
675: pay_all_payrolls pap,
676: pay_payroll_actions ppa
677: where pap.payroll_id = ptp.payroll_id
678: and pap.payroll_id=p_payroll_id
679: and ppa.payroll_id=pap.payroll_id

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:

Line 2249: pay_all_payrolls pap,

2245: ) return number is
2246:
2247: cursor c_last_pay_period is select max(ptp.period_num)
2248: from per_time_periods ptp,
2249: pay_all_payrolls pap,
2250: pay_payroll_actions ppa
2251: where pap.payroll_id = ptp.payroll_id
2252: and pap.payroll_id=p_payroll_id
2253: and ppa.payroll_id=pap.payroll_id