APPS.PAY_DYT_GLOBALS_PKG dependencies on PAY_CORE_UTILS

Line 83: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(

79: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
80: RETURN;
81: END IF;
82: /* INITIALISING LOCAL VARIABLES */
83: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
84: P_STATEMENT => 'SELECT
85: '||P_OLD_BUSINESS_GROUP_ID||' FROM SYS.DUAL'
86: );
87: --

Line 88: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(

84: P_STATEMENT => 'SELECT
85: '||P_OLD_BUSINESS_GROUP_ID||' FROM SYS.DUAL'
86: );
87: --
88: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
89: P_BG_ID => L_BUSINESS_GROUP_ID
90: );
91: --
92: /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */

Line 183: PAY_CORE_UTILS.GET_BUSINESS_GROUP(

179: RETURN;
180: END IF;
181: /* INITIALISING LOCAL VARIABLES */
182: L_BUSINESS_GROUP_ID :=
183: PAY_CORE_UTILS.GET_BUSINESS_GROUP(
184: P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM FF_GLOBALS_F '||' WHERE GLOBAL_ID = '|| P_NEW_GLOBAL_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'')
185: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
186: );
187: --

Line 188: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(

184: P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM FF_GLOBALS_F '||' WHERE GLOBAL_ID = '|| P_NEW_GLOBAL_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'')
185: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
186: );
187: --
188: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
189: P_BG_ID => L_BUSINESS_GROUP_ID
190: );
191: --
192: /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */

Line 291: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(

287: RETURN;
288: END IF;
289: /* INITIALISING LOCAL VARIABLES */
290:
291: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
292: P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM FF_GLOBALS_F WHERE GLOBAL_ID = ' ||P_NEW_GLOBAL_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE,
293: 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
294: );
295: --

Line 296: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(

292: P_STATEMENT => 'SELECT BUSINESS_GROUP_ID FROM FF_GLOBALS_F WHERE GLOBAL_ID = ' ||P_NEW_GLOBAL_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE,
293: 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE'
294: );
295: --
296: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
297: P_BG_ID => L_BUSINESS_GROUP_ID
298: );
299: --
300: /* IS THE TRIGGER IN