DBA Data[Home] [Help]

APPS.PER_CONTACT_RELATIONSHIPS_PKG dependencies on PER_COBRA_COV_ENROLLMENTS

Line 1864: FROM per_cobra_cov_enrollments

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

Line 2348: FROM per_cobra_cov_enrollments

2344: WHERE person_id = X_Person_Id;
2345: --
2346: CURSOR COBRA IS
2347: SELECT 'Y'
2348: FROM per_cobra_cov_enrollments
2349: WHERE CONTACT_RELATIONSHIP_ID = X_Contact_Relationship_Id;
2350: --
2351: --Changes for Bug no 5415267 starts here
2352: CURSOR Benificiary IS