APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_CARE_MED_V

Line 4707: p_rec in out nocopy pay_jp_isdf_care_med_v%rowtype,

4703: -- -------------------------------------------------------------------------
4704: -- transfer_care_med
4705: -- -------------------------------------------------------------------------
4706: procedure transfer_care_med(
4707: p_rec in out nocopy pay_jp_isdf_care_med_v%rowtype,
4708: p_effective_date in date,
4709: p_expire_after_transfer in varchar2)
4710: is
4711: --

Line 5315: from pay_jp_isdf_care_med_v

5311: -- ass eit exclude PC data, take only GIP/LINC
5312: cursor csr_care_med_del
5313: is
5314: select *
5315: from pay_jp_isdf_care_med_v
5316: where assignment_action_id = l_assact_rec.assignment_action_id
5317: and care_ins_class <> 'PC'
5318: and status = 'D'
5319: for update nowait;

Line 5325: from pay_jp_isdf_care_med_v

5321: -- status U is only case when archive was transfered
5322: cursor csr_care_med_upd
5323: is
5324: select *
5325: from pay_jp_isdf_care_med_v
5326: where assignment_action_id = l_assact_rec.assignment_action_id
5327: and care_ins_class <> 'PC'
5328: and status = 'Q'
5329: for update nowait;

Line 5334: from pay_jp_isdf_care_med_v

5330: --
5331: cursor csr_care_med_ins
5332: is
5333: select *
5334: from pay_jp_isdf_care_med_v
5335: where assignment_action_id = l_assact_rec.assignment_action_id
5336: and care_ins_class <> 'PC'
5337: and status = 'I'
5338: for update nowait;