APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_LIFE_PENS_V

Line 4002: p_rec in out nocopy pay_jp_isdf_life_pens_v%rowtype,

3998: -- -------------------------------------------------------------------------
3999: -- transfer_life_pens
4000: -- -------------------------------------------------------------------------
4001: procedure transfer_life_pens(
4002: p_rec in out nocopy pay_jp_isdf_life_pens_v%rowtype,
4003: p_effective_date in date,
4004: p_expire_after_transfer in varchar2)
4005: is
4006: --

Line 4425: from pay_jp_isdf_life_pens_v

4421: -- ass eit exclude PC data, take only GIP/LINC
4422: cursor csr_life_pens_del
4423: is
4424: select *
4425: from pay_jp_isdf_life_pens_v
4426: where assignment_action_id = l_assact_rec.assignment_action_id
4427: and pens_ins_class <> 'PC'
4428: and status = 'D'
4429: for update nowait;

Line 4435: from pay_jp_isdf_life_pens_v

4431: -- status U is only case when archive was transfered
4432: cursor csr_life_pens_upd
4433: is
4434: select *
4435: from pay_jp_isdf_life_pens_v
4436: where assignment_action_id = l_assact_rec.assignment_action_id
4437: and pens_ins_class <> 'PC'
4438: and status = 'Q'
4439: for update nowait;

Line 4444: from pay_jp_isdf_life_pens_v

4440: --
4441: cursor csr_life_pens_ins
4442: is
4443: select *
4444: from pay_jp_isdf_life_pens_v
4445: where assignment_action_id = l_assact_rec.assignment_action_id
4446: and pens_ins_class <> 'PC'
4447: and status = 'I'
4448: for update nowait;