APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_NONLIFE_V

Line 617: from pay_jp_isdf_nonlife_v pjin

613: pjin.beneficiary_name,
614: pjin.beneficiary_relship,
615: pjin.maturity_repayment,
616: pjin.annual_prem
617: from pay_jp_isdf_nonlife_v pjin
618: where pjin.assignment_action_id=p_mag_act_info_id
619: and pjin.status <> 'D';
620: --
621: type isdf_nonlife_ins_term_type_nl is table of varchar2(240) index by binary_integer;

Line 907: FROM pay_jp_isdf_nonlife_v pjin

903: END IF;
904: --
905: SELECT count(DISTINCT(action_information_id))
906: INTO count_nonlife
907: FROM pay_jp_isdf_nonlife_v pjin
908: WHERE pjin.assignment_action_id = l_mag_asg_action_id
909: and pjin.status <> 'D';
910: --
911: IF (count_nonlife = 0) THEN