DBA Data[Home] [Help]

APPS.PAY_PAYGBTPL_XMLP_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 55: PAY_BALANCE_DIMENSIONS

51: SELECT
52: BALANCE_DIMENSION_ID
53: INTO C_YTD_BAL_DIM_ID
54: FROM
55: PAY_BALANCE_DIMENSIONS
56: WHERE DIMENSION_NAME = '_ASG_TD_YTD'
57: AND LEGISLATION_CODE = 'GB';
58: SELECT
59: BALANCE_DIMENSION_ID

Line 62: PAY_BALANCE_DIMENSIONS

58: SELECT
59: BALANCE_DIMENSION_ID
60: INTO C_PTD_BAL_DIM_ID
61: FROM
62: PAY_BALANCE_DIMENSIONS
63: WHERE DIMENSION_NAME = '_ASG_TRANSFER_PTD'
64: AND LEGISLATION_CODE = 'GB';
65: SELECT
66: BALANCE_DIMENSION_ID

Line 69: PAY_BALANCE_DIMENSIONS

65: SELECT
66: BALANCE_DIMENSION_ID
67: INTO L_PROC_PTD_DIM
68: FROM
69: PAY_BALANCE_DIMENSIONS
70: WHERE DIMENSION_NAME = '_ASG_PROC_PTD'
71: AND LEGISLATION_CODE = 'GB';
72: OPEN INPUT_VALUES;
73: FETCH INPUT_VALUES