APPS.PAY_GB_FPS_NI_AND_OTHERS dependencies on PAY_PRE_PAYMENTS

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

51: 04-Mar-2013 pbalu 115.24 16386622 NI adjustment logic modified to check for ER run level values.
52: 11-Mar-2013 rajganga 115.25 16402171 Added fnd_canonical date conversion.
53: 15-Mar-2013 ssarap 115.26 16496657 Changed the data type of number(15) to number(15,2).
54: 19-Mar-2013 pbalu 115.27 16510056 Random digit fetching for BACS modified
55: 26-Mar-2013 ssarap 115.28 16306737 Added a third party prepayment check for pay_pre_payments tables
56: in function FPS_BACS_PREPROCESS.
57: 29-Mar-2013 ssarap 115.30 16555308 Added the assignment id OUT
58: param to fetch_HASH_FPS_PER. Fetch the assignment id of largest bacs.
59: =============================================================================*/

Line 3380: FROM pay_pre_payments ppp,

3376: lpad(ppp.value*100,11,'0') Amount,
3377: PAPF.PER_information10 Aggregation,
3378: 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,
3379: PAY_GB_FPS_NI_AND_OTHERS.BACS_RANDOM_DIGIT RandomStr
3380: FROM pay_pre_payments ppp,
3381: pay_payment_types ppt,
3382: pay_org_payment_methods_f popf,
3383: pay_personal_payment_methods_f pppf,
3384: pay_external_accounts Orgkey,