APPS.PV_PRGM_APPROVAL_PVT dependencies on PV_PARTNER_PROGRAM_TYPE_VL
Line 1594: SELECT ppv.program_name,to_char(ppv.program_type_id) from pv_partner_program_vl ppv, pv_partner_program_type_vl ppt
1590: l_string VARCHAR2 (3000);
1591:
1592: --the cursor below picks up the program type id based on the program id.
1593: CURSOR c_program_type_rec (p_program_id IN NUMBER) IS 1594: SELECT ppv.program_name,to_char(ppv.program_type_id) from pv_partner_program_vl ppv, pv_partner_program_type_vl ppt 1595: WHERE ppv.program_id=p_program_id
1596: AND ppv.program_type_id=ppt.program_type_id;
1597:
1598: