APPS.PAY_JP_DEF_SS dependencies on PAY_JP_DEF_ENTRY_V

Line 315: p_rec in out nocopy pay_jp_def_entry_v%rowtype,

311: -- |---------------------------------------------------------------------------|
312: -- |----------------------------< transfer_entry >-----------------------------|
313: -- |---------------------------------------------------------------------------|
314: procedure transfer_entry(
315: p_rec in out nocopy pay_jp_def_entry_v%rowtype,
316: p_dep_rec in out nocopy pay_jp_def_entry_dep_v%rowtype,
317: p_business_group_id in number)
318: is
319: c_proc constant varchar2(61) := c_package || '.transfer_entry';

Line 455: p_rec in out nocopy pay_jp_def_entry_v%rowtype,

451: -- |---------------------------------------------------------------------------|
452: -- |----------------------------< rollback_entry >-----------------------------|
453: -- |---------------------------------------------------------------------------|
454: procedure rollback_entry(
455: p_rec in out nocopy pay_jp_def_entry_v%rowtype,
456: p_dep_rec in out nocopy pay_jp_def_entry_dep_v%rowtype,
457: p_business_group_id in number)
458: is
459: c_proc constant varchar2(61) := c_package || '.rollback_entry';

Line 1790: l_entry_rec pay_jp_def_entry_v%rowtype;

1786: and pjsn_v.organization_id (+) = nvl(l_itax_organization_id,-1)
1787: and substrb(pjsn_v.act_district_code(+),1,5) = substrb(pjal_act.district_code,1,5)
1788: and substrb(pjal_rep.district_code(+),1,5) = pjsn_v.rep_district_code;
1789: --
1790: l_entry_rec pay_jp_def_entry_v%rowtype;
1791: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;
1792: l_entry_os_rec pay_jp_def_entry_os_v%rowtype;
1793: --
1794: l_csr_emp csr_emp%rowtype;

Line 2376: l_entry_rec pay_jp_def_entry_v%rowtype;

2372: l_business_group_id number;
2373: --
2374: l_submission_date date;
2375: l_assact_rec pay_jp_def_assact_v%rowtype;
2376: l_entry_rec pay_jp_def_entry_v%rowtype;
2377: l_entry_dep_rec pay_jp_def_entry_dep_v%rowtype;
2378: l_entry_os_rec pay_jp_def_entry_os_v%rowtype;
2379: l_emp_rec pay_jp_def_emp_v%rowtype;
2380: --

Line 2384: from pay_jp_def_entry_v

2380: --
2381: cursor csr_entry(p_assignment_action_id in number)
2382: is
2383: select *
2384: from pay_jp_def_entry_v
2385: where assignment_action_id = p_assignment_action_id
2386: for update nowait;
2387: --
2388: cursor csr_entry_dep(p_assignment_action_id in number)

Line 2895: l_entry_rec pay_jp_def_entry_v%rowtype;

2891: --
2892: c_proc constant varchar2(61) := c_package || 'do_transfer';
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;

Line 2904: from pay_jp_def_entry_v

2900: --
2901: cursor csr_entry(p_assignment_action_id number)
2902: is
2903: select *
2904: from pay_jp_def_entry_v
2905: where assignment_action_id = p_assignment_action_id
2906: for update nowait;
2907: --
2908: cursor csr_entry_dep(p_assignment_action_id number)

Line 3250: l_entry_rec pay_jp_def_entry_v%rowtype;

3246: --
3247: c_proc constant varchar2(61) := c_package ||'rollback_transfer';
3248: --
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;

Line 3260: from pay_jp_def_entry_v

3256: --
3257: cursor csr_entry(p_assignment_action_id number)
3258: is
3259: select *
3260: from pay_jp_def_entry_v
3261: where assignment_action_id = p_assignment_action_id
3262: for update nowait;
3263: --
3264: cursor csr_entry_dep(p_assignment_action_id number)

Line 3539: from pay_jp_def_entry_v v

3535: --
3536: cursor csr_entry(p_assignment_action_id number)
3537: is
3538: select v.*
3539: from pay_jp_def_entry_v v
3540: where v.assignment_action_id = p_assignment_action_id
3541: and exists(
3542: select null
3543: from pay_element_entries_f pee

Line 3807: from pay_jp_def_entry_v v

3803: p_assignment_action_id number,
3804: p_expiry_date date)
3805: is
3806: select v.*
3807: from pay_jp_def_entry_v v
3808: where v.assignment_action_id = p_assignment_action_id
3809: and exists(
3810: select null
3811: from pay_element_entries_f pee