DBA Data[Home] [Help]

APPS.PAY_GB_MULTI_PAYROLL_RUN dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 204: PAY_ORG_PAYMENT_METHODS_F POPMF

200: CURSOR CSR_DEF_PAY_METHOD (P_PAYROLL_ID IN NUMBER) IS
201: SELECT DISTINCT POPMF.ORG_PAYMENT_METHOD_NAME
202: FROM
203: PAY_ALL_PAYROLLS_F PAPF,
204: PAY_ORG_PAYMENT_METHODS_F POPMF
205: WHERE PAPF.DEFAULT_PAYMENT_METHOD_ID=POPMF.ORG_PAYMENT_METHOD_ID
206: AND PAPF.BUSINESS_GROUP_ID=POPMF.BUSINESS_GROUP_ID
207: AND PAPF.PAYROLL_ID=P_PAYROLL_ID;
208:

Line 460: ,PAY_ORG_PAYMENT_METHODS_F POPMF

456: FROM
457: PAY_PRE_PAYMENTS PPP
458: ,PAY_ASSIGNMENT_ACTIONS PAA
459: ,PER_ALL_ASSIGNMENTS_F PAAF
460: ,PAY_ORG_PAYMENT_METHODS_F POPMF
461: ,PER_TIME_PERIODS PTP
462: WHERE PPP.ASSIGNMENT_ACTION_ID=PAA.ASSIGNMENT_ACTION_ID
463: AND PAA.ASSIGNMENT_ID=PAAF.ASSIGNMENT_ID
464: AND PAAF.PAYROLL_ID=PTP.PAYROLL_ID