APPS.PAY_GB_RTI_FPS dependencies on PAY_PAYROLLS_F

Line 87: 07-Sep-2012 rajganga 115.58 14576477 Removed unused pay_payrolls_f and added not null check for balances.

83: 31-Aug-2012 rajganga 115.55 14549289 Fixed Payment after leaving indicator, added errors to the LOG file
84: Removed current emp flag check.
85: 03-Sep-2012 rajganga 115.56 14577359 Fixed Termination logic and output file.
86: 05-Sep-2012 ssarap 115.57 14549289 Fixed the NI Mismatch issue. Removed the swapping logic for archived values of NI context.
87: 07-Sep-2012 rajganga 115.58 14576477 Removed unused pay_payrolls_f and added not null check for balances.
88: 13-Sep-2012 ssarap 115.41 14365199 Fix for Interlocks, fix for balance doubling, fix for Retry.
89: 14-Sep-2012 ssarap 115.42 14365199 Modified to raise an error when First FPS is already ran.
90: 17-Sep-2012 rajganga 115.43 14365199 Modified to fix no data found issue.
91: 17-Sep-2012 rajganga 115.44 14365199 Modified to fix no data found issue, added one more condition check

Line 414: pay_payrolls_f pay,

410:
411: cursor csr_asg is
412: select paaf.assignment_id
413: from per_all_assignments_f paaf,
414: pay_payrolls_f pay,
415: hr_soft_coding_keyflex sck
416: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =p_assignment_id)
417: and pay.payroll_id = paaf.payroll_id
418: and pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID

Line 12458: from pay_payrolls_f ppf,pay_payroll_actions ppapre,pay_payroll_actions ppa

12454:
12455: CURSOR csr_payroll_details
12456: IS
12457: SELECT ppf.PAYROLL_NAME , ppapre.EFFECTIVE_DATE
12458: from pay_payrolls_f ppf,pay_payroll_actions ppapre,pay_payroll_actions ppa
12459: WHERE ppa.payroll_action_id = pactid
12460: and ppf.payroll_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PAYROLL_ID'),1,20)
12461: and ppapre.payroll_action_id = SUBSTR(pay_gb_eoy_archive.get_parameter(ppa.legislative_parameters,'PRE_PAY_ID'),1,20);
12462: