APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_LIFE_PENS_V

Line 583: FROM pay_jp_isdf_life_pens_v pjilp

579: pjilp.contractor_name,
580: pjilp.beneficiary_name,
581: pjilp.beneficiary_relship,
582: pjilp.annual_prem
583: FROM pay_jp_isdf_life_pens_v pjilp
584: WHERE pjilp.assignment_action_id=p_mag_act_info_id
585: and pjilp.status <> 'D';
586: --
587: TYPE isdf_ins_company_name_lp IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;

Line 893: FROM pay_jp_isdf_life_pens_v pjilp

889: END IF;
890: --
891: SELECT count(DISTINCT(action_information_id))
892: INTO count_life_pens
893: FROM pay_jp_isdf_life_pens_v pjilp
894: WHERE pjilp.assignment_action_id = l_mag_asg_action_id
895: and pjilp.status <> 'D';
896: --
897: IF (count_life_pens = 0) THEN