APPS.PAY_JP_DEF_SS dependencies on PAY_JP_DEF_DEP_V

Line 581: procedure transfer_dep(p_rec in out nocopy pay_jp_def_dep_v%rowtype)

577: end rollback_entry;
578: -- |---------------------------------------------------------------------------|
579: -- |-----------------------------< transfer_dep >------------------------------|
580: -- |---------------------------------------------------------------------------|
581: procedure transfer_dep(p_rec in out nocopy pay_jp_def_dep_v%rowtype)
582: is
583: c_proc constant varchar2(61) := c_package || '.transfer_dep';
584: l_esd date;
585: l_eed date;

Line 679: procedure rollback_dep(p_rec in out nocopy pay_jp_def_dep_v%rowtype)

675: end transfer_dep;
676: -- |---------------------------------------------------------------------------|
677: -- |-----------------------------< rollback_dep >------------------------------|
678: -- |---------------------------------------------------------------------------|
679: procedure rollback_dep(p_rec in out nocopy pay_jp_def_dep_v%rowtype)
680: is
681: c_proc constant varchar2(61) := c_package || '.rollback_dep';
682: l_esd date;
683: l_eed date;

Line 2411: from pay_jp_def_dep_v

2407: --
2408: cursor csr_dep(p_assignment_action_id in number)
2409: is
2410: select *
2411: from pay_jp_def_dep_v
2412: where assignment_action_id = p_assignment_action_id
2413: and status <> 'D'
2414: order by decode(contact_type, 'S', 1, 2), date_of_birth, last_name_kana, first_name_kana;
2415: --

Line 2897: l_dep_rec pay_jp_def_dep_v%rowtype;

2893: --
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)

Line 2928: from pay_jp_def_dep_v

2924: --
2925: cursor csr_dep_del(p_assignment_action_id number)
2926: is
2927: select *
2928: from pay_jp_def_dep_v
2929: where assignment_action_id = p_assignment_action_id
2930: and status = 'D'
2931: for update nowait;
2932: --

Line 2936: from pay_jp_def_dep_v

2932: --
2933: cursor csr_dep_upd(p_assignment_action_id number)
2934: is
2935: select *
2936: from pay_jp_def_dep_v
2937: where assignment_action_id = p_assignment_action_id
2938: and status = 'Q'
2939: for update nowait;
2940: --

Line 2944: from pay_jp_def_dep_v

2940: --
2941: cursor csr_dep_ins(p_assignment_action_id number)
2942: is
2943: select *
2944: from pay_jp_def_dep_v
2945: where assignment_action_id = p_assignment_action_id
2946: and status = 'I'
2947: for update nowait;
2948: --

Line 3253: l_dep_rec pay_jp_def_dep_v%rowtype;

3249: l_assact_rec pay_jp_def_assact_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)

Line 3284: from pay_jp_def_dep_v

3280: --
3281: cursor csr_dep_ins(p_assignment_action_id number)
3282: is
3283: select *
3284: from pay_jp_def_dep_v
3285: where assignment_action_id = p_assignment_action_id
3286: and status = 'I'
3287: for update nowait;
3288: --

Line 3292: from pay_jp_def_dep_v

3288: --
3289: cursor csr_dep_upd(p_assignment_action_id number)
3290: is
3291: select *
3292: from pay_jp_def_dep_v
3293: where assignment_action_id = p_assignment_action_id
3294: and status = 'U'
3295: for update nowait;
3296: --

Line 3300: from pay_jp_def_dep_v

3296: --
3297: cursor csr_dep_del(p_assignment_action_id number)
3298: is
3299: select *
3300: from pay_jp_def_dep_v
3301: where assignment_action_id = p_assignment_action_id
3302: and status = 'D'
3303: for update nowait;
3304: --

Line 3565: from pay_jp_def_dep_v v

3561: --
3562: cursor csr_dep(p_assignment_action_id number)
3563: is
3564: select v.*
3565: from pay_jp_def_dep_v v
3566: where v.assignment_action_id = p_assignment_action_id
3567: and status <> 'D'
3568: and exists(
3569: select null

Line 3837: from pay_jp_def_dep_v v

3833: p_assignment_action_id number,
3834: p_expiry_date date)
3835: is
3836: select v.*
3837: from pay_jp_def_dep_v v
3838: where v.assignment_action_id = p_assignment_action_id
3839: and status <> 'D'
3840: and exists(
3841: select null