APPS.PSP_ARCHIVE_RETRIEVE dependencies on PAY_PAYROLLS_F

Line 131: FROM PAY_PAYROLLS_F PPF

127:
128: -- Cursors to get payroll name, begin period name, end period name for displaying in the messages
129: CURSOR payroll_name_cur IS
130: SELECT distinct PPF.payroll_name
131: FROM PAY_PAYROLLS_F PPF
132: WHERE PPF.payroll_id = p_payroll_id
133: and PPF.business_group_id = p_business_group_id
134: and PPF.gl_set_of_books_id = p_set_of_books_id;
135:

Line 657: FROM PAY_PAYROLLS_F PPF

653:
654: -- Cursors to get payroll name, begin period name, end period name for displaying in the messages
655: CURSOR payroll_name_cur IS
656: SELECT distinct PPF.payroll_name
657: FROM PAY_PAYROLLS_F PPF
658: WHERE PPF.payroll_id = p_payroll_id
659: and PPF.business_group_id = p_business_group_id
660: and PPF.gl_set_of_books_id = p_set_of_books_id;
661:

Line 1082: FROM PAY_PAYROLLS_F PPF,

1078:
1079: -- Cursor to get payroll name, begin period name, end period name for displaying in the messages
1080: CURSOR parameter_cur
1081: IS SELECT distinct PPF.payroll_name, PTP1.period_name, PTP2.period_name
1082: FROM PAY_PAYROLLS_F PPF,
1083: PER_TIME_PERIODS PTP1,
1084: PER_TIME_PERIODS PTP2
1085: WHERE PPF.payroll_id = p_payroll_id
1086: AND PTP1.payroll_id = p_payroll_id

Line 1365: FROM PAY_PAYROLLS_F PPF,

1361:
1362: -- Cursor to get payroll name, begin period name, end period name for displaying in the messages
1363: CURSOR parameter_cur
1364: IS SELECT distinct PPF.payroll_name, PTP1.period_name, PTP2.period_name
1365: FROM PAY_PAYROLLS_F PPF,
1366: PER_TIME_PERIODS PTP1,
1367: PER_TIME_PERIODS PTP2
1368: WHERE PPF.payroll_id = p_payroll_id
1369: AND PTP1.payroll_id = p_payroll_id