APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_LIFE_GEN_V

Line 552: FROM pay_jp_isdf_life_gen_v pjilg

548: pjilg.contractor_name,
549: pjilg.beneficiary_name,
550: pjilg.beneficiary_relship,
551: pjilg.annual_prem
552: FROM pay_jp_isdf_life_gen_v pjilg
553: WHERE pjilg.assignment_action_id=p_mag_act_info_id
554: and pjilg.status <> 'D';
555: --
556: TYPE isdf_ins_company_name_lg IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;

Line 879: FROM pay_jp_isdf_life_gen_v pjilg

875: -- Code to determine the number of pages start.
876: --
877: SELECT count(DISTINCT(action_information_id))
878: INTO count_life_gen
879: FROM pay_jp_isdf_life_gen_v pjilg
880: WHERE pjilg.assignment_action_id = l_mag_asg_action_id
881: and pjilg.status <> 'D';
882: --
883: IF (count_life_gen = 0) THEN