DBA Data[Home] [Help]

APPS.PV_USER_RESP_PVT dependencies on PV_PROGRAM_BENEFITS

Line 1467: FROM pv_program_benefits ben

1463: )
1464: IS
1465: CURSOR get_resp_id IS
1466: SELECT ben.benefit_id, ben.program_benefits_id
1467: FROM pv_program_benefits ben
1468: WHERE
1469: ben.benefit_type_code = 'STORES'
1470: AND ben.delete_flag = 'N'
1471: AND ben.program_id in

Line 1610: FROM pv_program_benefits ben

1606: )
1607: IS
1608: CURSOR get_resp_id IS
1609: SELECT ben.benefit_id, ben.program_benefits_id
1610: FROM pv_program_benefits ben
1611: WHERE ben.program_id IN (
1612: SELECT program_id
1613: FROM pv_partner_program_b
1614: START WITH program_id = p_program_id