DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_GB_EOY_ARCHIVE

Line 687: SELECT TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PAYROLL_ID')) PAYROLL_ID,

683: P_TIME_PERIOD_ID NUMBER;
684: -- Concurrent Program Parameters
685: CURSOR CSR_CP_INFO
686: IS
687: SELECT TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PAYROLL_ID')) PAYROLL_ID,
688: TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PERIOD_ID')) TIME_PERIOD_ID,
689: PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS,'MODE') L_MODE,
690: BUSINESS_GROUP_ID
691: FROM PAY_PAYROLL_ACTIONS

Line 688: TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PERIOD_ID')) TIME_PERIOD_ID,

684: -- Concurrent Program Parameters
685: CURSOR CSR_CP_INFO
686: IS
687: SELECT TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PAYROLL_ID')) PAYROLL_ID,
688: TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PERIOD_ID')) TIME_PERIOD_ID,
689: PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS,'MODE') L_MODE,
690: BUSINESS_GROUP_ID
691: FROM PAY_PAYROLL_ACTIONS
692: WHERE PAYROLL_ACTION_ID = G_PAYROLL_ACTION_ID ;

Line 689: PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS,'MODE') L_MODE,

685: CURSOR CSR_CP_INFO
686: IS
687: SELECT TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PAYROLL_ID')) PAYROLL_ID,
688: TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PERIOD_ID')) TIME_PERIOD_ID,
689: PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS,'MODE') L_MODE,
690: BUSINESS_GROUP_ID
691: FROM PAY_PAYROLL_ACTIONS
692: WHERE PAYROLL_ACTION_ID = G_PAYROLL_ACTION_ID ;
693: --Tax details Reference for staging date and postponement rule.

Line 3234: SELECT TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PAYROLL_ID')) PAYROLL_ID,

3230: --Bug 14370667
3231: -- Concurrent Program Parameters
3232: CURSOR CSR_ACT_CP_INFO
3233: IS
3234: SELECT TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PAYROLL_ID')) PAYROLL_ID,
3235: TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PERIOD_ID')) TIME_PERIOD_ID,
3236: BUSINESS_GROUP_ID
3237: FROM PAY_PAYROLL_ACTIONS
3238: WHERE PAYROLL_ACTION_ID = p_payroll_action_id ;

Line 3235: TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PERIOD_ID')) TIME_PERIOD_ID,

3231: -- Concurrent Program Parameters
3232: CURSOR CSR_ACT_CP_INFO
3233: IS
3234: SELECT TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PAYROLL_ID')) PAYROLL_ID,
3235: TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PERIOD_ID')) TIME_PERIOD_ID,
3236: BUSINESS_GROUP_ID
3237: FROM PAY_PAYROLL_ACTIONS
3238: WHERE PAYROLL_ACTION_ID = p_payroll_action_id ;
3239: l_act_payroll_id NUMBER;