DBA Data[Home] [Help]

APPS.PAY_GB_EPS_13 dependencies on FND_GLOBAL

Line 441: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),

437: hr_utility.set_location('Status : '||l_status,40);
438: UPDATE
439: PAY_GB_EPS_DETAILS
440: SET STATUS = l_status,
441: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
442: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
443: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
444: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
445: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference

Line 442: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),

438: UPDATE
439: PAY_GB_EPS_DETAILS
440: SET STATUS = l_status,
441: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
442: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
443: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
444: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
445: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
446: AND EFFECTIVE_DATE = p_effective_date

Line 443: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),

439: PAY_GB_EPS_DETAILS
440: SET STATUS = l_status,
441: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
442: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
443: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
444: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
445: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
446: AND EFFECTIVE_DATE = p_effective_date
447: AND BUSINESS_GROUP_ID = p_business_group_id;

Line 444: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)

440: SET STATUS = l_status,
441: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
442: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
443: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
444: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
445: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
446: AND EFFECTIVE_DATE = p_effective_date
447: AND BUSINESS_GROUP_ID = p_business_group_id;
448:

Line 751: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),

747: NO_PAYMENT_DATE_TO = p_no_payment_date_to,
748: PERIOD_OF_INACTIVITY_FROM = p_period_of_inactivity_from,
749: PERIOD_OF_INACTIVITY_TO = p_period_of_inactivity_to,
750: DATE_SCHEME_CEASED = p_date_scheme_ceased,
751: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
752: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
753: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
754: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
755: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference

Line 752: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),

748: PERIOD_OF_INACTIVITY_FROM = p_period_of_inactivity_from,
749: PERIOD_OF_INACTIVITY_TO = p_period_of_inactivity_to,
750: DATE_SCHEME_CEASED = p_date_scheme_ceased,
751: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
752: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
753: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
754: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
755: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
756: AND EFFECTIVE_DATE = p_effective_date

Line 753: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),

749: PERIOD_OF_INACTIVITY_TO = p_period_of_inactivity_to,
750: DATE_SCHEME_CEASED = p_date_scheme_ceased,
751: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
752: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
753: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
754: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
755: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
756: AND EFFECTIVE_DATE = p_effective_date
757: AND BUSINESS_GROUP_ID = p_business_group_id;

Line 754: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)

750: DATE_SCHEME_CEASED = p_date_scheme_ceased,
751: REQUEST_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, request_id, FND_GLOBAL.CONC_REQUEST_ID),
752: PROGRAM_APPLICATION_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_application_id, FND_GLOBAL.PROG_APPL_ID),
753: PROGRAM_ID = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_id, FND_GLOBAL.CONC_PROGRAM_ID),
754: PROGRAM_UPDATE_DATE = DECODE(FND_GLOBAL.CONC_REQUEST_ID, -1, program_update_date, SYSDATE)
755: WHERE EMP_PAYE_REFERENCE = p_emp_paye_reference
756: AND EFFECTIVE_DATE = p_effective_date
757: AND BUSINESS_GROUP_ID = p_business_group_id;
758: