APPS.PAY_GB_FPS_NI_AND_OTHERS_13 dependencies on PAY_PRE_PAYMENTS

Line 22: 26-Mar-2013 ssarap 115.10 16306737 Added a third party prepayment check for pay_pre_payments tables

18: 04-Mar-2013 sampmand 115.4 16386622 NI adjustment logic modified to check for ER run level values.
19: 11-Mar-2013 rajganga 115.6 16402171 Added fnd_canonical date conversion.
20: 15-Mar-2013 ssarap 115.7 16496657 Changed the data type of number(15) to number(15,2).
21: 19-Mar-2013 pbalu 115.8 16510056 Random digit fetching for BACS modified
22: 26-Mar-2013 ssarap 115.10 16306737 Added a third party prepayment check for pay_pre_payments tables
23: in function FPS_BACS_PREPROCESS.
24: 29-Mar-2013 ssarap 115.11 16555308 Added the assignment id OUT
25: param to fetch_HASH_FPS_PER. Fetch the assignment id of largest bacs.
26: =============================================================================*/

Line 3375: FROM pay_pre_payments ppp,

3371: lpad(ppp.value*100,11,'0') Amount,
3372: PAPF.PER_information10 Aggregation,
3373: DECODE(PAPF.PER_information10,'Y',RANK() OVER (PARTITION BY PAA.PAYROLL_ACTION_ID,PAPF.PERSON_ID order by ppp.value DESC),RANK() OVER (PARTITION BY PAA.PAYROLL_ACTION_ID,PAA.ASSIGNMENT_ID order by ppp.value DESC)) highest,
3374: PAY_GB_FPS_NI_AND_OTHERS_13.BACS_RANDOM_DIGIT RandomStr
3375: FROM pay_pre_payments ppp,
3376: pay_payment_types ppt,
3377: pay_org_payment_methods_f popf,
3378: pay_personal_payment_methods_f pppf,
3379: pay_external_accounts Orgkey,