APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_NONLIFE_V

Line 4185: p_rec in out nocopy pay_jp_isdf_nonlife_v%rowtype,

4181: -- -------------------------------------------------------------------------
4182: -- transfer_nonlife
4183: -- -------------------------------------------------------------------------
4184: procedure transfer_nonlife(
4185: p_rec in out nocopy pay_jp_isdf_nonlife_v%rowtype,
4186: p_effective_date in date,
4187: p_expire_after_transfer in varchar2)
4188: is
4189: --

Line 4454: from pay_jp_isdf_nonlife_v

4450: -- ass eit exclude PC data, take only AP
4451: cursor csr_nonlife_del
4452: is
4453: select *
4454: from pay_jp_isdf_nonlife_v
4455: where assignment_action_id = l_assact_rec.assignment_action_id
4456: and nonlife_ins_class <> 'PC'
4457: and status = 'D'
4458: for update nowait;

Line 4464: from pay_jp_isdf_nonlife_v

4460: -- status U is only case when archive was transfered
4461: cursor csr_nonlife_upd
4462: is
4463: select *
4464: from pay_jp_isdf_nonlife_v
4465: where assignment_action_id = l_assact_rec.assignment_action_id
4466: and nonlife_ins_class <> 'PC'
4467: and status = 'Q'
4468: for update nowait;

Line 4473: from pay_jp_isdf_nonlife_v

4469: --
4470: cursor csr_nonlife_ins
4471: is
4472: select *
4473: from pay_jp_isdf_nonlife_v
4474: where assignment_action_id = l_assact_rec.assignment_action_id
4475: and nonlife_ins_class <> 'PC'
4476: and status = 'I'
4477: for update nowait;