APPS.PAY_JP_BALANCE_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 123: p_dimension_name IN PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE,

119: END get_element_input_id;
120: --
121: --===============================================================================
122: FUNCTION get_defined_balance_id(p_balance_name IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,
123: p_dimension_name IN PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE,
124: p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE)
125: --===============================================================================
126: RETURN NUMBER
127: IS

Line 136: INDEX(PAY_BALANCE_DIMENSIONS_PK PBD) */

132: select /*+ ORDERED
133: USE_NL(PBT, PDB, PBD)
134: INDEX(PAY_BALANCE_TYPES_UK2 PBT)
135: INDEX(PAY_DEFINED_BALANCES_UK2 PDB)
136: INDEX(PAY_BALANCE_DIMENSIONS_PK PBD) */
137: pdb.defined_balance_id
138: from pay_balance_types pbt,
139: pay_defined_balances pdb,
140: pay_balance_dimensions pbd

Line 140: pay_balance_dimensions pbd

136: INDEX(PAY_BALANCE_DIMENSIONS_PK PBD) */
137: pdb.defined_balance_id
138: from pay_balance_types pbt,
139: pay_defined_balances pdb,
140: pay_balance_dimensions pbd
141: where pbt.balance_name = p_balance_name
142: and nvl(pbt.business_group_id,p_business_group_id) = p_business_group_id
143: and nvl(pbt.legislation_code,l_legislation_code) = l_legislation_code
144: and pbd.dimension_name = p_dimension_name

Line 199: P_DIMENSION_NAME IN PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE,

195: -- GET_BALANCE_VALUE (action mode) --
196: --------------------------------------------------------------
197: FUNCTION GET_BALANCE_VALUE(
198: P_BALANCE_NAME IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,
199: P_DIMENSION_NAME IN PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE,
200: P_ASSIGNMENT_ACTION_ID IN NUMBER)
201: RETURN NUMBER
202: IS
203: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

Line 252: P_DIMENSION_NAME IN PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE,

248: -- GET_BALANCE_VALUE (date mode) --
249: -------------------------------------------------------------
250: FUNCTION GET_BALANCE_VALUE(
251: P_BALANCE_NAME IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,
252: P_DIMENSION_NAME IN PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE,
253: P_ASSIGNMENT_ID IN NUMBER,
254: P_EFFECTIVE_DATE IN DATE)
255: RETURN NUMBER
256: IS

Line 1208: l_dimension_name PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE;

1204: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
1205: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
1206: l_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
1207: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;
1208: l_dimension_name PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE;
1209: l_save_run_balance PAY_DEFINED_BALANCES.SAVE_RUN_BALANCE%TYPE;
1210:
1211: BEGIN
1212: l_business_group_id := get_business_group_id(P_ASSIGNMENT_ID,P_EFFECTIVE_DATE);