APPS.PV_ENRL_PREREQ_BINS_PUB dependencies on PV_PARTNER_PROGRAM_B

Line 104: pv_partner_program_b e

100: FROM pv_enty_select_criteria a,
101: pv_selected_attr_values b,
102: pv_attributes_vl c,
103: pv_process_rules_b d,
104: pv_partner_program_b e
105: WHERE a.attribute_id = c.attribute_id AND
106: a.selection_criteria_id = b.selection_criteria_id (+) AND
107: a.process_rule_id = d.process_rule_id AND
108: d.process_rule_id = e.prereq_process_rule_id AND

Line 371: FROM pv_partner_program_b prg

367: -- Cursors
368: -- -----------------------------------------------------------------------
369: CURSOR c_get_program_ids IS
370: SELECT prg.program_id
371: FROM pv_partner_program_b prg
372: WHERE prg.program_status_code = 'ACTIVE'
373: AND prg.program_level_code = 'MEMBERSHIP'
374: AND NVL(prg.allow_enrl_until_date, SYSDATE +1) >= SYSDATE
375: AND prg.enabled_flag = 'Y';