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 PER_BUSINESS_GROUPS

Line 14: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

10: FUNCTION get_business_group_id(p_assignment_action_id IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
11: --===============================================================================
12: RETURN NUMBER
13: IS
14: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
15:
16: CURSOR get_business_group_id IS
17: select /*+ ORDERED
18: USE_NL(PAA, PPA)

Line 44: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

40: p_effective_date IN DATE)
41: --===============================================================================
42: RETURN NUMBER
43: IS
44: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
45:
46: CURSOR get_business_group_id IS
47: select /*+ INDEX(PER_ASSIGNMENTS_F_PK PA) */
48: pa.business_group_id

Line 65: FUNCTION get_legislation_code(p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE)

61: return l_business_group_id;
62: END get_business_group_id;
63: --
64: --===============================================================================
65: FUNCTION get_legislation_code(p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE)
66: --===============================================================================
67: RETURN VARCHAR2
68: IS
69: l_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;

Line 69: l_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;

65: FUNCTION get_legislation_code(p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE)
66: --===============================================================================
67: RETURN VARCHAR2
68: IS
69: l_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
70:
71: CURSOR get_legislation_code IS
72: select pbg.legislation_code
73: from per_business_groups pbg

Line 73: from per_business_groups pbg

69: l_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
70:
71: CURSOR get_legislation_code IS
72: select pbg.legislation_code
73: from per_business_groups pbg
74: where pbg.business_group_id = p_business_group_id;
75: BEGIN
76: OPEN get_legislation_code;
77: FETCH get_legislation_code INTO l_legislation_code;

Line 90: p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,

86: --===============================================================================
87: PROCEDURE get_element_input_id(
88: p_element_name IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
89: p_input_value_name IN PAY_INPUT_VALUES_F.NAME%TYPE,
90: p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,
91: p_element_type_id IN OUT NOCOPY NUMBER,
92: p_input_value_id IN OUT NOCOPY NUMBER)
93: --===============================================================================
94: IS

Line 95: l_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;

91: p_element_type_id IN OUT NOCOPY NUMBER,
92: p_input_value_id IN OUT NOCOPY NUMBER)
93: --===============================================================================
94: IS
95: l_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
96: BEGIN
97: l_legislation_code:=get_legislation_code(p_business_group_id);
98: if l_legislation_code is NULL then
99: p_element_type_id:=NULL;

Line 124: p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE)

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
128: l_defined_balance_id NUMBER;

Line 129: l_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;

125: --===============================================================================
126: RETURN NUMBER
127: IS
128: l_defined_balance_id NUMBER;
129: l_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;
130:
131: CURSOR get_defined_balance_id IS
132: select /*+ ORDERED
133: USE_NL(PBT, PDB, PBD)

Line 169: p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,

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
173: IS

Line 170: p_legislation_code IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)

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
173: IS
174: l_balance_type_id NUMBER;

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

Line 234: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

230: P_DEFINED_BALANCE_ID IN NUMBER,
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;

Line 257: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

253: P_ASSIGNMENT_ID IN NUMBER,
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;

Line 417: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

413: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
414: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
415: RETURN NUMBER
416: IS
417: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
418: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
419: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
420: l_result_value NUMBER;
421: BEGIN

Line 504: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

500: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
501: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
502: RETURN VARCHAR2
503: IS
504: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
505: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
506: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
507: l_result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE;
508: BEGIN

Line 585: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

581: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
582: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
583: RETURN NUMBER
584: IS
585: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
586: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
587: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
588: l_result_value NUMBER;
589: BEGIN

Line 667: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

663: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
664: P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
665: RETURN DATE
666: IS
667: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
668: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
669: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
670: l_result_value DATE;
671: BEGIN

Line 752: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

748: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
749: P_EFFECTIVE_DATE IN DATE)
750: RETURN VARCHAR2
751: IS
752: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
753: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
754: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
755: l_entry_value PAY_ELEMENT_ENTRY_VALUES_F.SCREEN_ENTRY_VALUE%TYPE;
756: BEGIN

Line 841: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

837: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
838: P_EFFECTIVE_DATE IN DATE)
839: RETURN NUMBER
840: IS
841: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
842: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
843: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
844: -- Modified by keyazawa at 2003/09/03 for bug#3088039
845: l_entry_value number;

Line 933: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

929: P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
930: P_EFFECTIVE_DATE IN DATE)
931: RETURN DATE
932: IS
933: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
934: l_element_type_id PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_ID%TYPE;
935: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
936: -- Modified by keyazawa at 2003/09/03 for bug#3088039
937: l_entry_value date;

Line 1025: P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)

1021: -----------------------------------------------------
1022: FUNCTION GET_ELEMENT_TYPE_ID(
1023: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
1024: P_BUSINESS_GROUP_ID IN NUMBER,
1025: P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
1026: RETURN NUMBER
1027: IS
1028: l_element_type_id NUMBER;
1029:

Line 1082: P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)

1078: FUNCTION GET_INPUT_VALUE_ID(
1079: P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
1080: P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
1081: P_BUSINESS_GROUP_ID IN NUMBER,
1082: P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
1083: RETURN NUMBER
1084: IS
1085: l_element_type_id NUMBER;
1086: l_input_value_id NUMBER;

Line 1116: p_legislation_code in per_business_groups.legislation_code%type)

1112: FUNCTION get_loc_uni_seq_input_value_id(
1113: p_element_name in pay_element_types_f.element_name%type,
1114: p_input_value_disp_seq in pay_input_values_f.display_sequence%type,
1115: p_business_group_id in number,
1116: p_legislation_code in per_business_groups.legislation_code%type)
1117: return number
1118: IS
1119: --
1120: l_element_type_id number;

Line 1165: P_BUSINESS_GROUP_ID IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,

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
1169: --===============================================================================

Line 1166: P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE

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
1169: --===============================================================================
1170: l_save_run_balance PAY_DEFINED_BALANCES.SAVE_RUN_BALANCE%TYPE;

Line 1195: p_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,

1191: )
1192: RETURN NUMBER IS
1193: --===============================================================================
1194: CURSOR get_balance_name(
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

Line 1196: p_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE

1192: RETURN NUMBER IS
1193: --===============================================================================
1194: CURSOR get_balance_name(
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

Line 1205: l_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;

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;
1209: l_save_run_balance PAY_DEFINED_BALANCES.SAVE_RUN_BALANCE%TYPE;

Line 1206: l_legislation_code PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE;

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;
1209: l_save_run_balance PAY_DEFINED_BALANCES.SAVE_RUN_BALANCE%TYPE;
1210: