APPS.PER_CONTACT_RELATIONSHIPS_PKG dependencies on PER_COBRA_COV_ENROLLMENTS

Line 1863: FROM per_cobra_cov_enrollments

1859: WHERE contact_relationship_id = X_Contact_Relationship_Id
1860: AND contact_type <> X_Contact_Type
1861: AND EXISTS
1862: (SELECT NULL
1863: FROM per_cobra_cov_enrollments
1864: WHERE CONTACT_RELATIONSHIP_ID = X_Contact_Relationship_Id);
1865: --
1866: --
1867: -- Start of Fix for WWBUG 1408379

Line 2336: FROM per_cobra_cov_enrollments

2332: WHERE person_id = X_Person_Id;
2333: --
2334: CURSOR COBRA IS
2335: SELECT 'Y'
2336: FROM per_cobra_cov_enrollments
2337: WHERE CONTACT_RELATIONSHIP_ID = X_Contact_Relationship_Id;
2338: --
2339: --Changes for Bug no 5415267 starts here
2340: CURSOR Benificiary IS