APPS.PAY_JP_ISDF_RPT dependencies on PAY_JP_ISDF_CARE_MED_V

Line 600: FROM pay_jp_isdf_care_med_v pjcmi

596: pjcmi.contractor_name,
597: pjcmi.beneficiary_name,
598: pjcmi.beneficiary_relship,
599: pjcmi.annual_prem
600: FROM pay_jp_isdf_care_med_v pjcmi
601: WHERE pjcmi.assignment_action_id=p_mag_act_info_id
602: and pjcmi.status <> 'D';
603: --
604: TYPE isdf_ins_company_name_lcm IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;

Line 1088: FROM pay_jp_isdf_care_med_v pjicm

1084:
1085: IF isdf_employer_c.effective_date >= c_st_upd_date_2012 then
1086: SELECT count(DISTINCT(action_information_id))
1087: INTO count_care_med
1088: FROM pay_jp_isdf_care_med_v pjicm
1089: WHERE pjicm.assignment_action_id = l_mag_asg_action_id
1090: and pjicm.status <> 'D';
1091: --
1092: IF (count_care_med = 0) THEN