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_DEFINED_BALANCES

Line 135: INDEX(PAY_DEFINED_BALANCES_UK2 PDB)

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,
139: pay_defined_balances pdb,

Line 139: pay_defined_balances pdb,

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
143: and nvl(pbt.legislation_code,l_legislation_code) = l_legislation_code

Line 204: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%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;
204: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
205: l_result_value NUMBER;
206: BEGIN
207: l_result_value := 0;
208:

Line 235: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

231: P_ASSIGNMENT_ACTION_ID IN NUMBER)
232: RETURN NUMBER
233: IS
234: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
235: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
236: l_result_value NUMBER;
237: BEGIN
238: l_result_value := 0;
239:

Line 258: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

254: P_EFFECTIVE_DATE IN DATE)
255: RETURN NUMBER
256: IS
257: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
258: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
259: l_result_value NUMBER;
260: BEGIN
261: l_result_value := 0;
262:

Line 318: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

314: P_ASSIGNMENT_ACTION_ID IN NUMBER)
315: RETURN NUMBER
316: IS
317: l_result_value NUMBER;
318: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
319: CURSOR cur_balance_value_asg_run IS
320: SELECT /*+ ORDERED
321: USE_NL(ASSACT, PACT, FEED, RR, TARGET)
322: INDEX(PAY_ASSIGNMENT_ACTIONS_PK ASSACT)

Line 1170: l_save_run_balance PAY_DEFINED_BALANCES.SAVE_RUN_BALANCE%TYPE;

1166: P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE
1167: )
1168: RETURN VARCHAR2 IS
1169: --===============================================================================
1170: l_save_run_balance PAY_DEFINED_BALANCES.SAVE_RUN_BALANCE%TYPE;
1171:
1172: BEGIN
1173:
1174: SELECT SAVE_RUN_BALANCE

Line 1176: FROM PAY_DEFINED_BALANCES

1172: BEGIN
1173:
1174: SELECT SAVE_RUN_BALANCE
1175: INTO l_save_run_balance
1176: FROM PAY_DEFINED_BALANCES
1177: WHERE BALANCE_TYPE_ID = P_BALANCE_TYPE_ID
1178: AND nvl(BUSINESS_GROUP_ID,p_business_group_id) = p_business_group_id
1179: AND nvl(LEGISLATION_CODE,p_legislation_code) = p_legislation_code;
1180:

Line 1204: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

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

Line 1209: l_save_run_balance PAY_DEFINED_BALANCES.SAVE_RUN_BALANCE%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);
1213: l_legislation_code := get_legislation_code(l_business_group_id);

Line 1256: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;

1252: PAY_PAYROLL_ACTIONS PPA
1253: WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
1254: AND PAA.ASSIGNMENT_ACTION_ID = p_assignment_action_id;
1255:
1256: l_defined_balance_id PAY_DEFINED_BALANCES.DEFINED_BALANCE_ID%TYPE;
1257: l_assignment_id PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE;
1258: l_effective_date PAY_PAYROLL_ACTIONS.EFFECTIVE_DATE%TYPE;
1259:
1260: BEGIN