DBA Data[Home] [Help]

APPS.PAY_DYT_DURATION_SUMMARY_PKG dependencies on PER_BUSINESS_GROUPS

Line 81: FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;

77: EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
78: --
79: SELECT LEGISLATION_CODE
80: INTO L_LEGISLATION_CODE
81: FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;
82: --
83: /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
84: IF
85: PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(

Line 178: FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;

174: L_DATE_START BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
175: --
176: SELECT LEGISLATION_CODE
177: INTO L_LEGISLATION_CODE
178: FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;
179: --
180: /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL
181: AREA */
182: IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(

Line 284: FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;

280: --
281: SELECT LEGISLATION_CODE
282: INTO L_LEGISLATION_CODE
283:
284: FROM PER_BUSINESS_GROUPS WHERE BUSINESS_GROUP_ID = L_BUSINESS_GROUP_ID;
285: --
286: /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
287: IF PAYWSFGT_PKG.TRIGGER_IS_NOT_ENABLED(
288: P_EVENT_ID => 1156,