75: RETURN;
76: END IF;
77: /* INITIALISING LOCAL VARIABLES */
78: L_BUSINESS_GROUP_ID :=
79: PAY_CORE_UTILS.GET_BUSINESS_GROUP_WITHBIND(
80: P_STATEMENT => 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF, PAY_ELEMENT_ENTRIES_F PEE WHERE PEE.ELEMENT_ENTRY_ID = :P_BINDVAR AND PEE.EFFECTIVE_START_DATE BETWEEN
81: PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE AND PAF.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID AND ROWNUM =1',
82: P_BINDVAR => P_OLD_ELEMENT_ENTRY_ID
83: );
81: PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE AND PAF.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID AND ROWNUM =1',
82: P_BINDVAR => P_OLD_ELEMENT_ENTRY_ID
83: );
84: --
85: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
86: P_BG_ID
87: => L_BUSINESS_GROUP_ID
88: );
89: --