APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_ISDF_LIFE_GEN_V

Line 4522: p_rec in out nocopy pay_jp_isdf_life_gen_v%rowtype,

4518: -- -------------------------------------------------------------------------
4519: -- transfer_life_gen
4520: -- -------------------------------------------------------------------------
4521: procedure transfer_life_gen(
4522: p_rec in out nocopy pay_jp_isdf_life_gen_v%rowtype,
4523: p_effective_date in date,
4524: p_expire_after_transfer in varchar2)
4525: is
4526: --

Line 5286: from pay_jp_isdf_life_gen_v

5282: -- ass eit exclude PC data, take only GIP/LINC
5283: cursor csr_life_gen_del
5284: is
5285: select *
5286: from pay_jp_isdf_life_gen_v
5287: where assignment_action_id = l_assact_rec.assignment_action_id
5288: and gen_ins_class <> 'PC'
5289: and status = 'D'
5290: for update nowait;

Line 5296: from pay_jp_isdf_life_gen_v

5292: -- status U is only case when archive was transfered
5293: cursor csr_life_gen_upd
5294: is
5295: select *
5296: from pay_jp_isdf_life_gen_v
5297: where assignment_action_id = l_assact_rec.assignment_action_id
5298: and gen_ins_class <> 'PC'
5299: and status = 'Q'
5300: for update nowait;

Line 5305: from pay_jp_isdf_life_gen_v

5301: --
5302: cursor csr_life_gen_ins
5303: is
5304: select *
5305: from pay_jp_isdf_life_gen_v
5306: where assignment_action_id = l_assact_rec.assignment_action_id
5307: and gen_ins_class <> 'PC'
5308: and status = 'I'
5309: for update nowait;