DBA Data[Home] [Help]

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: