DBA Data[Home] [Help]

APPS.BEN_ICD_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 134: FROM ben_icd_transaction icd, pay_element_types_f pet

130: l_null varchar2(1):=null;
131:
132: CURSOR c_entry_exists is
133: SELECT NULL
134: FROM ben_icd_transaction icd, pay_element_types_f pet
135: WHERE icd.assignment_id = P_ASSIGNMENT_ID
136: AND NVL(icd.effective_date,icd.effective_start_date) = nvl(P_EFFECTIVE_DATE,P_EFFECTIVE_START_DATE)
137: AND icd.element_type_id = P_ELEMENT_TYPE_ID
138: AND icd.transaction_id = P_TRANSACTION_ID

Line 540: FROM ben_icd_transaction icd, pay_element_types_f pet

536: l_null varchar2(1):=null;
537:
538: CURSOR c_entry_exists is
539: SELECT NULL
540: FROM ben_icd_transaction icd, pay_element_types_f pet
541: WHERE icd.assignment_id = P_ASSIGNMENT_ID
542: AND NVL(icd.effective_date,icd.effective_start_date) = nvl(P_EFFECTIVE_DATE,P_EFFECTIVE_START_DATE)
543: AND icd.element_type_id = P_ELEMENT_TYPE_ID
544: AND icd.transaction_id = P_TRANSACTION_ID

Line 709: FROM ben_icd_transaction icd, pay_element_types_f pet

705: l_null varchar2(1):=null;
706:
707: CURSOR c_entry_exists is
708: SELECT NULL
709: FROM ben_icd_transaction icd, pay_element_types_f pet
710: WHERE icd.assignment_id = P_ASSIGNMENT_ID
711: AND NVL(icd.effective_date,icd.effective_start_date) = nvl(P_EFFECTIVE_DATE,P_EFFECTIVE_START_DATE)
712: AND icd.element_type_id = P_ELEMENT_TYPE_ID
713: AND icd.transaction_id = P_TRANSACTION_ID