APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_LIFE_GEN_V

Line 568: FROM pay_jp_isdf_life_gen_v pjilg

564: pjilg.beneficiary_name,
565: pjilg.beneficiary_relship,
566: pjilg.annual_prem,
567: pjilg.gen_ins_class_old_new
568: FROM pay_jp_isdf_life_gen_v pjilg
569: WHERE pjilg.assignment_action_id=p_mag_act_info_id
570: and pjilg.status <> 'D';
571: --
572: TYPE isdf_ins_company_name_lg IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;

Line 1001: FROM pay_jp_isdf_life_gen_v pjilg

997: -- Code to determine the number of pages start.
998: --
999: SELECT count(DISTINCT(action_information_id))
1000: INTO count_life_gen
1001: FROM pay_jp_isdf_life_gen_v pjilg
1002: WHERE pjilg.assignment_action_id = l_mag_asg_action_id
1003: and pjilg.status <> 'D';
1004: --
1005: IF isdf_employer_c.effective_date < c_st_upd_date_2012 then