154: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
155: RETURN;
156: END IF;
157: /* INITIALISING LOCAL VARIABLES */
158: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP_WITHBIND(
159: P_STATEMENT => 'SELECT
160: DISTINCT BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = :P_BINDVAR',
161: P_BINDVAR => P_OLD_ASSIGNMENT_ID
162: );
160: DISTINCT BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = :P_BINDVAR',
161: P_BINDVAR => P_OLD_ASSIGNMENT_ID
162: );
163: --
164: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
165: P_BG_ID =>
166: L_BUSINESS_GROUP_ID
167: );
168: --
320: RETURN;
321: END IF;
322: /* INITIALISING LOCAL
323: VARIABLES */
324: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP_WITHBIND(
325: P_STATEMENT => 'SELECT DISTINCT BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = :P_BINDVAR',
326: P_BINDVAR =>
327: P_NEW_ASSIGNMENT_ID
328: );
326: P_BINDVAR =>
327: P_NEW_ASSIGNMENT_ID
328: );
329: --
330: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
331: P_BG_ID => L_BUSINESS_GROUP_ID
332: );
333: --
334: /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
573:
574: RETURN;
575: END IF;
576: /* INITIALISING LOCAL VARIABLES */
577: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP_WITHBIND(
578: P_STATEMENT => 'SELECT DISTINCT BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = :P_BINDVAR',
579:
580: P_BINDVAR => P_OLD_ASSIGNMENT_ID
581: );
579:
580: P_BINDVAR => P_OLD_ASSIGNMENT_ID
581: );
582: --
583: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
584: P_BG_ID => L_BUSINESS_GROUP_ID
585: );
586: --
587: /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */
745: L_EFFECTIVE_START_DATE := P_NEW_EFFECTIVE_START_DATE;
746: --
747: L_ASSIGNMENT_ID := P_NEW_ASSIGNMENT_ID;
748: --
749: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP_WITHBIND(
750: P_STATEMENT
751: => 'SELECT DISTINCT BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = :P_BINDVAR',
752: P_BINDVAR => P_NEW_ASSIGNMENT_ID
753: );
751: => 'SELECT DISTINCT BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F WHERE ASSIGNMENT_ID = :P_BINDVAR',
752: P_BINDVAR => P_NEW_ASSIGNMENT_ID
753: );
754: --
755: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
756: P_BG_ID
757: => L_BUSINESS_GROUP_ID
758: );
759: --