APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_NONLIFE_V

Line 5075: p_rec in out nocopy pay_jp_isdf_nonlife_v%rowtype,

5071: -- -------------------------------------------------------------------------
5072: -- transfer_nonlife
5073: -- -------------------------------------------------------------------------
5074: procedure transfer_nonlife(
5075: p_rec in out nocopy pay_jp_isdf_nonlife_v%rowtype,
5076: p_effective_date in date,
5077: p_expire_after_transfer in varchar2)
5078: is
5079: --

Line 5374: from pay_jp_isdf_nonlife_v

5370: -- ass eit exclude PC data, take only AP
5371: cursor csr_nonlife_del
5372: is
5373: select *
5374: from pay_jp_isdf_nonlife_v
5375: where assignment_action_id = l_assact_rec.assignment_action_id
5376: and nonlife_ins_class <> 'PC'
5377: and status = 'D'
5378: for update nowait;

Line 5384: from pay_jp_isdf_nonlife_v

5380: -- status U is only case when archive was transfered
5381: cursor csr_nonlife_upd
5382: is
5383: select *
5384: from pay_jp_isdf_nonlife_v
5385: where assignment_action_id = l_assact_rec.assignment_action_id
5386: and nonlife_ins_class <> 'PC'
5387: and status = 'Q'
5388: for update nowait;

Line 5393: from pay_jp_isdf_nonlife_v

5389: --
5390: cursor csr_nonlife_ins
5391: is
5392: select *
5393: from pay_jp_isdf_nonlife_v
5394: where assignment_action_id = l_assact_rec.assignment_action_id
5395: and nonlife_ins_class <> 'PC'
5396: and status = 'I'
5397: for update nowait;