APPS.PAY_JP_DEF_SS dependencies on PAY_JP_DEF_DEP_OE_V

Line 811: procedure transfer_dep_oe(p_rec in out nocopy pay_jp_def_dep_oe_v%rowtype)

807: end rollback_dep;
808: -- |---------------------------------------------------------------------------|
809: -- |----------------------------< transfer_dep_oe >----------------------------|
810: -- |---------------------------------------------------------------------------|
811: procedure transfer_dep_oe(p_rec in out nocopy pay_jp_def_dep_oe_v%rowtype)
812: is
813: c_proc constant varchar2(61) := c_package || '.transfer_dep_oe';
814: l_esd date;
815: l_eed date;

Line 900: procedure rollback_dep_oe(p_rec in out nocopy pay_jp_def_dep_oe_v%rowtype)

896: end transfer_dep_oe;
897: -- |---------------------------------------------------------------------------|
898: -- |-----------------------------< rollback_dep >------------------------------|
899: -- |---------------------------------------------------------------------------|
900: procedure rollback_dep_oe(p_rec in out nocopy pay_jp_def_dep_oe_v%rowtype)
901: is
902: c_proc constant varchar2(61) := c_package || '.rollback_dep_oe';
903: l_esd date;
904: l_eed date;

Line 2898: l_dep_oe_rec pay_jp_def_dep_oe_v%rowtype;

2894: l_assact_rec pay_jp_def_assact_v%rowtype;
2895: l_entry_rec pay_jp_def_entry_v%rowtype;
2896: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;
2897: l_dep_rec pay_jp_def_dep_v%rowtype;
2898: l_dep_oe_rec pay_jp_def_dep_oe_v%rowtype;
2899: l_dep_os_rec pay_jp_def_dep_os_v%rowtype;
2900: --
2901: cursor csr_entry(p_assignment_action_id number)
2902: is

Line 2955: from pay_jp_def_dep_oe_v

2951: --
2952: cursor csr_dep_oe_del(p_assignment_action_id number)
2953: is
2954: select *
2955: from pay_jp_def_dep_oe_v
2956: where assignment_action_id = p_assignment_action_id
2957: and status = 'D'
2958: for update nowait;
2959: --

Line 2963: from pay_jp_def_dep_oe_v

2959: --
2960: cursor csr_dep_oe_upd(p_assignment_action_id number)
2961: is
2962: select *
2963: from pay_jp_def_dep_oe_v
2964: where assignment_action_id = p_assignment_action_id
2965: and status = 'Q'
2966: for update nowait;
2967: --

Line 2971: from pay_jp_def_dep_oe_v

2967: --
2968: cursor csr_dep_oe_ins(p_assignment_action_id number)
2969: is
2970: select *
2971: from pay_jp_def_dep_oe_v
2972: where assignment_action_id = p_assignment_action_id
2973: and status = 'I'
2974: for update nowait;
2975: --

Line 3254: l_dep_oe_rec pay_jp_def_dep_oe_v%rowtype;

3250: l_entry_rec pay_jp_def_entry_v%rowtype;
3251: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;
3252: l_entry_os_rec pay_jp_def_entry_os_v%rowtype;
3253: l_dep_rec pay_jp_def_dep_v%rowtype;
3254: l_dep_oe_rec pay_jp_def_dep_oe_v%rowtype;
3255: l_dep_os_rec pay_jp_def_dep_os_v%rowtype;
3256: --
3257: cursor csr_entry(p_assignment_action_id number)
3258: is

Line 3311: from pay_jp_def_dep_oe_v

3307: --
3308: cursor csr_dep_oe_ins(p_assignment_action_id number)
3309: is
3310: select *
3311: from pay_jp_def_dep_oe_v
3312: where assignment_action_id = p_assignment_action_id
3313: and status = 'I'
3314: for update nowait;
3315: --

Line 3319: from pay_jp_def_dep_oe_v

3315: --
3316: cursor csr_dep_oe_upd(p_assignment_action_id number)
3317: is
3318: select *
3319: from pay_jp_def_dep_oe_v
3320: where assignment_action_id = p_assignment_action_id
3321: and status = 'U'
3322: for update nowait;
3323: --

Line 3327: from pay_jp_def_dep_oe_v

3323: --
3324: cursor csr_dep_oe_del(p_assignment_action_id number)
3325: is
3326: select *
3327: from pay_jp_def_dep_oe_v
3328: where assignment_action_id = p_assignment_action_id
3329: and status = 'D'
3330: for update nowait;
3331: --

Line 3579: from pay_jp_def_dep_oe_v v

3575: --
3576: cursor csr_dep_oe(p_assignment_action_id number)
3577: is
3578: select v.*
3579: from pay_jp_def_dep_oe_v v
3580: where v.assignment_action_id = p_assignment_action_id
3581: and status <> 'D'
3582: and exists(
3583: select null

Line 3853: from pay_jp_def_dep_oe_v v

3849: p_assignment_action_id number,
3850: p_expiry_date date)
3851: is
3852: select v.*
3853: from pay_jp_def_dep_oe_v v
3854: where v.assignment_action_id = p_assignment_action_id
3855: and status <> 'D'
3856: and exists(
3857: select null