APPS.PAY_JP_DEF_SS dependencies on PAY_JP_DEF_DEP_OS_V

Line 1026: procedure transfer_dep_os(p_rec in out nocopy pay_jp_def_dep_os_v%rowtype)

1022: end rollback_dep_oe;
1023: -- |---------------------------------------------------------------------------|
1024: -- |----------------------------< transfer_dep_os >----------------------------|
1025: -- |---------------------------------------------------------------------------|
1026: procedure transfer_dep_os(p_rec in out nocopy pay_jp_def_dep_os_v%rowtype)
1027: is
1028: c_proc constant varchar2(61) := c_package || '.transfer_dep_os';
1029: l_esd date;
1030: l_eed date;

Line 1114: procedure rollback_dep_os(p_rec in out nocopy pay_jp_def_dep_os_v%rowtype)

1110: end transfer_dep_os;
1111: -- |---------------------------------------------------------------------------|
1112: -- |-----------------------------< rollback_dep_os >---------------------------|
1113: -- |---------------------------------------------------------------------------|
1114: procedure rollback_dep_os(p_rec in out nocopy pay_jp_def_dep_os_v%rowtype)
1115: is
1116: c_proc constant varchar2(61) := c_package || '.rollback_dep_os';
1117: l_esd date;
1118: l_eed date;

Line 2899: l_dep_os_rec pay_jp_def_dep_os_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
2903: select *

Line 2982: from pay_jp_def_dep_os_v

2978: --
2979: cursor csr_dep_os_del(p_assignment_action_id number)
2980: is
2981: select *
2982: from pay_jp_def_dep_os_v
2983: where assignment_action_id = p_assignment_action_id
2984: and status = 'D'
2985: for update nowait;
2986: --

Line 2990: from pay_jp_def_dep_os_v

2986: --
2987: cursor csr_dep_os_upd(p_assignment_action_id number)
2988: is
2989: select *
2990: from pay_jp_def_dep_os_v
2991: where assignment_action_id = p_assignment_action_id
2992: and status = 'Q'
2993: for update nowait;
2994: --

Line 2998: from pay_jp_def_dep_os_v

2994: --
2995: cursor csr_dep_os_ins(p_assignment_action_id number)
2996: is
2997: select *
2998: from pay_jp_def_dep_os_v
2999: where assignment_action_id = p_assignment_action_id
3000: and status = 'I'
3001: for update nowait;
3002: --

Line 3255: l_dep_os_rec pay_jp_def_dep_os_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
3259: select *

Line 3338: from pay_jp_def_dep_os_v

3334: --
3335: cursor csr_dep_os_ins(p_assignment_action_id number)
3336: is
3337: select *
3338: from pay_jp_def_dep_os_v
3339: where assignment_action_id = p_assignment_action_id
3340: and status = 'I'
3341: for update nowait;
3342: --

Line 3346: from pay_jp_def_dep_os_v

3342: --
3343: cursor csr_dep_os_upd(p_assignment_action_id number)
3344: is
3345: select *
3346: from pay_jp_def_dep_os_v
3347: where assignment_action_id = p_assignment_action_id
3348: and status = 'U'
3349: for update nowait;
3350: --

Line 3354: from pay_jp_def_dep_os_v

3350: --
3351: cursor csr_dep_os_del(p_assignment_action_id number)
3352: is
3353: select *
3354: from pay_jp_def_dep_os_v
3355: where assignment_action_id = p_assignment_action_id
3356: and status = 'D'
3357: for update nowait;
3358: --

Line 3593: from pay_jp_def_dep_os_v v

3589: --
3590: cursor csr_dep_os(p_assignment_action_id number)
3591: is
3592: select v.*
3593: from pay_jp_def_dep_os_v v
3594: where v.assignment_action_id = p_assignment_action_id
3595: and status <> 'D'
3596: and exists(
3597: select null

Line 3869: from pay_jp_def_dep_os_v v

3865: p_assignment_action_id number,
3866: p_expiry_date date)
3867: is
3868: select v.*
3869: from pay_jp_def_dep_os_v v
3870: where v.assignment_action_id = p_assignment_action_id
3871: and status <> 'D'
3872: and exists(
3873: select null