APPS.BEN_ICD_PKG dependencies on BEN_ICD_TRANSACTION

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 155: INSERT INTO BEN_ICD_TRANSACTION

151: hr_utility.raise_error;
152: end if;
153: close c_entry_exists;
154:
155: INSERT INTO BEN_ICD_TRANSACTION
156: (
157: ICD_TRANSACTION_ID
158: ,ICD_CHC_RATE_ID
159: ,BUSINESS_GROUP_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 563: ben_icd_transaction

559: end if;
560: close c_entry_exists;
561:
562: update
563: ben_icd_transaction
564: set
565: ICD_CHC_RATE_ID = P_ICD_CHC_RATE_ID
566: ,BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
567: ,PERSON_ID = P_PERSON_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