APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_LIFE_PENS_V

Line 632: FROM pay_jp_isdf_life_pens_v pjilp

628: pjilp.beneficiary_name,
629: pjilp.beneficiary_relship,
630: pjilp.annual_prem,
631: pjilp.pens_ins_class_old_new
632: FROM pay_jp_isdf_life_pens_v pjilp
633: WHERE pjilp.assignment_action_id=p_mag_act_info_id
634: and pjilp.status <> 'D';
635: --
636: TYPE isdf_ins_company_name_lp IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;

Line 1025: FROM pay_jp_isdf_life_pens_v pjilp

1021: END IF;
1022: --
1023: SELECT count(DISTINCT(action_information_id))
1024: INTO count_life_pens
1025: FROM pay_jp_isdf_life_pens_v pjilp
1026: WHERE pjilp.assignment_action_id = l_mag_asg_action_id
1027: and pjilp.status <> 'D';
1028: --
1029: IF isdf_employer_c.effective_date < c_st_upd_date_2012 then