APPS.PAY_DYT_ELEMENT_ENTRIES_PKG dependencies on PAY_CORE_UTILS

Line 243: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(

239:
240: RETURN;
241: END IF;
242: /* INITIALISING LOCAL VARIABLES */
243: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
244: P_STATEMENT => 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID =
245: '||P_OLD_ASSIGNMENT_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
246: );
247: --

Line 248: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(

244: P_STATEMENT => 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID =
245: '||P_OLD_ASSIGNMENT_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
246: );
247: --
248: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
249:
250: P_BG_ID => L_BUSINESS_GROUP_ID
251: );
252: --

Line 410: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(

406: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
407: RETURN;
408: END IF;
409: /* INITIALISING LOCAL VARIABLES */
410: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
411: P_STATEMENT => 'SELECT
412: PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID = '||P_OLD_ASSIGNMENT_ID||' AND TO_DATE('''||TO_CHAR(P_OLD_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
413: );
414:

Line 416: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(

412: PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID = '||P_OLD_ASSIGNMENT_ID||' AND TO_DATE('''||TO_CHAR(P_OLD_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
413: );
414:
415: --
416: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
417: P_BG_ID => L_BUSINESS_GROUP_ID
418: );
419: --
420: /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */

Line 576: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(

572: RETURN;
573: END IF;
574: /* INITIALISING LOCAL
575: VARIABLES */
576: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
577: P_STATEMENT => 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID = '||P_NEW_ASSIGNMENT_ID||' AND
578: TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
579: );
580: --

Line 581: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(

577: P_STATEMENT => 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID = '||P_NEW_ASSIGNMENT_ID||' AND
578: TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
579: );
580: --
581: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
582: P_BG_ID
583: => L_BUSINESS_GROUP_ID
584: );
585: --

Line 747: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(

743: L_EFFECTIVE_START_DATE := P_NEW_EFFECTIVE_START_DATE;
744: --
745: L_ASSIGNMENT_ID := P_NEW_ASSIGNMENT_ID;
746: --
747: L_BUSINESS_GROUP_ID := PAY_CORE_UTILS.GET_BUSINESS_GROUP(
748: P_STATEMENT =>
749: 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID = '||P_NEW_ASSIGNMENT_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD/MM/YYYY')||''',''DD/MM/YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
750:
751: );

Line 753: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(

749: 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF WHERE ASSIGNMENT_ID = '||P_NEW_ASSIGNMENT_ID||' AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD/MM/YYYY')||''',''DD/MM/YYYY'') BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE'
750:
751: );
752: --
753: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
754: P_BG_ID => L_BUSINESS_GROUP_ID
755: );
756: --
757: /* IS THE TRIGGER IN AN ENABLED FUNCTIONAL AREA */