eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_BALANCE_PKG dependencies on PAY_BALANCE_TYPES

Line 122: FUNCTION get_defined_balance_id(p_balance_name IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,

118: NULL;
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

Line 134: INDEX(PAY_BALANCE_TYPES_UK2 PBT)

130:
131: CURSOR get_defined_balance_id IS
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,

Line 138: from pay_balance_types pbt,

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
141: where pbt.balance_name = p_balance_name
142: and nvl(pbt.business_group_id,p_business_group_id) = p_business_group_id

Line 168: p_balance_name IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,

164: END get_defined_balance_id;
165:
166: --===============================================================================
167: FUNCTION GET_BALANCE_TYPE_ID(
168: p_balance_name IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,
169: p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,
170: p_legislation_code IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
171: --===============================================================================
172: RETURN NUMBER

Line 177: select /+ INDEX(PAY_BALANCE_TYPES_UK2 PBT) /

173: IS
174: l_balance_type_id NUMBER;
175:
176: CURSOR cur_balance_type_id IS
177: select /*+ INDEX(PAY_BALANCE_TYPES_UK2 PBT) */
178: pbt.balance_type_id
179: from pay_balance_types pbt
180: where pbt.balance_name = p_balance_name
181: and nvl(pbt.business_group_id,p_business_group_id) = p_business_group_id

Line 179: from pay_balance_types pbt

175:
176: CURSOR cur_balance_type_id IS
177: select /*+ INDEX(PAY_BALANCE_TYPES_UK2 PBT) */
178: pbt.balance_type_id
179: from pay_balance_types pbt
180: where pbt.balance_name = p_balance_name
181: and nvl(pbt.business_group_id,p_business_group_id) = p_business_group_id
182: and nvl(pbt.legislation_code,p_legislation_code) = p_legislation_code;
183: BEGIN

Line 198: P_BALANCE_NAME IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,

194: --------------------------------------------------------------
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

Line 251: P_BALANCE_NAME IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,

247: -------------------------------------------------------------
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

Line 1164: P_BALANCE_TYPE_ID IN PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE,

1160: END get_loc_uni_seq_input_value_id;
1161: --
1162: --===============================================================================
1163: FUNCTION GET_SAVE_RUN_BALANCE(
1164: P_BALANCE_TYPE_ID IN PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE,
1165: P_BUSINESS_GROUP_ID IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,
1166: P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE
1167: )
1168: RETURN VARCHAR2 IS

Line 1188: P_BALANCE_TYPE_ID IN PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE,

1184: RETURN NULL;
1185: END GET_SAVE_RUN_BALANCE;
1186: --===============================================================================
1187: FUNCTION GET_DEFINED_BALANCE_ID(
1188: P_BALANCE_TYPE_ID IN PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE,
1189: P_ASSIGNMENT_ID IN PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
1190: P_EFFECTIVE_DATE IN DATE
1191: )
1192: RETURN NUMBER IS

Line 1199: FROM PAY_BALANCE_TYPES

1195: p_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,
1196: p_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE
1197: ) IS
1198: SELECT BALANCE_NAME
1199: FROM PAY_BALANCE_TYPES
1200: WHERE nvl(BUSINESS_GROUP_ID,p_business_group_id) = p_business_group_id
1201: AND nvl(LEGISLATION_CODE,p_legislation_code) = p_legislation_code
1202: AND BALANCE_TYPE_ID = p_balance_type_id;
1203:

Line 1207: l_balance_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;

1203:
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

Line 1239: P_BALANCE_TYPE_ID IN PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE,

1235: END GET_DEFINED_BALANCE_ID;
1236: --
1237: --===============================================================================
1238: FUNCTION GET_DEFINED_BALANCE_ID(
1239: P_BALANCE_TYPE_ID IN PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE,
1240: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE
1241: )
1242: RETURN NUMBER IS
1243: --===============================================================================