APPS.PV_PRGM_APPROVAL_PVT dependencies on PV_GE_QSNR_ELEMENTS_B

Line 2568: FROM pv_ge_qsnr_elements_b

2564:
2565: /**
2566: CURSOR check_attr_exist(p_program_id NUMBER) IS
2567: SELECT 'X' from dual where exists( SELECT distinct(entity_attr_id)
2568: FROM pv_ge_qsnr_elements_b
2569: WHERE arc_used_by_entity_code='PRGM'
2570: AND used_by_entity_id in
2571: ( SELECT program_id
2572: FROM pv_partner_program_b

Line 2581: FROM pv_ge_qsnr_elements_b qsnr, pv_entity_attrs attr

2577: */
2578:
2579: CURSOR check_attr_exist(p_program_id NUMBER) IS
2580: SELECT 'X' from dual where exists( SELECT distinct(attr.attribute_id)
2581: FROM pv_ge_qsnr_elements_b qsnr, pv_entity_attrs attr
2582: WHERE arc_used_by_entity_code='PRGM'
2583: AND attr.ENTITY_ATTR_ID=qsnr.entity_attr_id
2584: AND used_by_entity_id in
2585: ( SELECT program_id

Line 2595: FROM pv_ge_qsnr_elements_b qsnr, pv_entity_attrs attr

2591:
2592:
2593: CURSOR attribute_id_csr(p_program_id NUMBER) IS
2594: SELECT distinct(attr.attribute_id)
2595: FROM pv_ge_qsnr_elements_b qsnr, pv_entity_attrs attr
2596: WHERE arc_used_by_entity_code='PRGM'
2597: AND attr.ENTITY_ATTR_ID=qsnr.entity_attr_id
2598: AND used_by_entity_id in
2599: ( SELECT program_id

Line 2609: FROM pv_ge_qsnr_elements_b

2605:
2606:
2607: /**
2608: SELECT distinct(entity_attr_id)
2609: FROM pv_ge_qsnr_elements_b
2610: WHERE arc_used_by_entity_code='PRGM'
2611: AND used_by_entity_id in
2612: ( SELECT program_id
2613: FROM pv_partner_program_b