APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_LIFE_GEN_V

Line 3822: p_rec in out nocopy pay_jp_isdf_life_gen_v%rowtype,

3818: -- -------------------------------------------------------------------------
3819: -- transfer_life_gen
3820: -- -------------------------------------------------------------------------
3821: procedure transfer_life_gen(
3822: p_rec in out nocopy pay_jp_isdf_life_gen_v%rowtype,
3823: p_effective_date in date,
3824: p_expire_after_transfer in varchar2)
3825: is
3826: --

Line 4396: from pay_jp_isdf_life_gen_v

4392: -- ass eit exclude PC data, take only GIP/LINC
4393: cursor csr_life_gen_del
4394: is
4395: select *
4396: from pay_jp_isdf_life_gen_v
4397: where assignment_action_id = l_assact_rec.assignment_action_id
4398: and gen_ins_class <> 'PC'
4399: and status = 'D'
4400: for update nowait;

Line 4406: from pay_jp_isdf_life_gen_v

4402: -- status U is only case when archive was transfered
4403: cursor csr_life_gen_upd
4404: is
4405: select *
4406: from pay_jp_isdf_life_gen_v
4407: where assignment_action_id = l_assact_rec.assignment_action_id
4408: and gen_ins_class <> 'PC'
4409: and status = 'Q'
4410: for update nowait;

Line 4415: from pay_jp_isdf_life_gen_v

4411: --
4412: cursor csr_life_gen_ins
4413: is
4414: select *
4415: from pay_jp_isdf_life_gen_v
4416: where assignment_action_id = l_assact_rec.assignment_action_id
4417: and gen_ins_class <> 'PC'
4418: and status = 'I'
4419: for update nowait;