DBA Data[Home] [Help]

APPS.PAY_DYT_ELEMENT_ENTRY_VAL_PKG dependencies on PAY_CORE_UTILS

Line 79: PAY_CORE_UTILS.GET_BUSINESS_GROUP(

75: RETURN;
76: END IF;
77: /* INITIALISING LOCAL VARIABLES */
78: L_BUSINESS_GROUP_ID :=
79: PAY_CORE_UTILS.GET_BUSINESS_GROUP(
80: P_STATEMENT => 'SELECT PAF.BUSINESS_GROUP_ID FROM PER_ASSIGNMENTS_F PAF, PAY_ELEMENT_ENTRIES_F PEE WHERE PEE.ELEMENT_ENTRY_ID = '||P_OLD_ELEMENT_ENTRY_ID||' AND
81: 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 AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN
82: PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE AND PAF.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID'
83: );

Line 85: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(

81: 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 AND TO_DATE('''||TO_CHAR(P_NEW_EFFECTIVE_START_DATE, 'DD-MON-YYYY')||''',''DD-MON-YYYY'') BETWEEN
82: PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE AND PAF.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID'
83: );
84: --
85: L_LEGISLATION_CODE := PAY_CORE_UTILS.GET_LEGISLATION_CODE(
86: P_BG_ID => L_BUSINESS_GROUP_ID
87: );
88: --
89: /* IS THE