APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_SOCIAL_V

Line 649: FROM pay_jp_isdf_social_v pjis

645: pjis.ins_payee_name,
646: pjis.debtor_name,
647: pjis.beneficiary_relship,
648: pjis.annual_prem
649: FROM pay_jp_isdf_social_v pjis
650: WHERE pjis.assignment_action_id=p_mag_act_info_id
651: and pjis.status <> 'D';
652: --
653: TYPE isdf_ins_type_s IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;

Line 921: FROM pay_jp_isdf_social_v pjis

917: END IF;
918: --
919: SELECT count(DISTINCT(action_information_id))
920: INTO count_social
921: FROM pay_jp_isdf_social_v pjis
922: WHERE pjis.assignment_action_id = l_mag_asg_action_id
923: and pjis.status <> 'D';
924: --
925: IF (count_social = 0) THEN