APPS.PV_ATTRIBUTE_CODE_PVT dependencies on PV_PARTNER_PROGRAM_VL

Line 293: from pv_partner_program_vl pp, pv_partner_program_type_b pt,

289: seleted.attribute_value=code.attr_code;
290:
291: cursor lc_check_programs (pc_attr_code_id number) is
292: select pp.program_id, pp.program_name, ppt.partner_type
293: from pv_partner_program_vl pp, pv_partner_program_type_b pt,
294: pv_program_partner_types ppt, pv_attribute_codes_vl code
295: where
296: pp.program_type_id = ppt.program_type_id
297: and pp.PROGRAM_STATUS_CODE NOT IN ('CANCEL', 'CLOSED','ARCHIVE')