APPS.PN_LEASE_PVT dependencies on PN_CONTACT_ASSIGNMENTS_V

Line 3458: FROM pn_contact_assignments_v

3454: ) THEN
3455: BEGIN
3456: SELECT lease_role,lease_role_type
3457: INTO p_lease_contacts_tbl (i).role,p_lease_contacts_tbl (i).role_code
3458: FROM pn_contact_assignments_v
3459: WHERE contact_assignment_id = p_lease_contacts_tbl (i).contact_assignment_id;
3460: EXCEPTION
3461: WHEN OTHERS THEN
3462: ----------------------dbms_output.put_line('Exception: No Data Retrived for the role');--Rupak