APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_SOCIAL_V

Line 700: FROM pay_jp_isdf_social_v pjis

696: pjis.ins_payee_name,
697: pjis.debtor_name,
698: pjis.beneficiary_relship,
699: pjis.annual_prem
700: FROM pay_jp_isdf_social_v pjis
701: WHERE pjis.assignment_action_id=p_mag_act_info_id
702: and pjis.status <> 'D';
703: --
704: TYPE isdf_ins_type_s IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;

Line 1063: FROM pay_jp_isdf_social_v pjis

1059: END IF;
1060: --
1061: SELECT count(DISTINCT(action_information_id))
1062: INTO count_social
1063: FROM pay_jp_isdf_social_v pjis
1064: WHERE pjis.assignment_action_id = l_mag_asg_action_id
1065: and pjis.status <> 'D';
1066: --
1067: IF isdf_employer_c.effective_date < c_st_upd_date_2012 then