APPS.PAY_JP_DEF_SS dependencies on PAY_JP_DEF_ENTRY_OS_V

Line 1243: p_rec in out nocopy pay_jp_def_entry_os_v%rowtype,

1239: -- -------------------------------------------------------------------------
1240: -- transfer_entry_os
1241: -- -------------------------------------------------------------------------
1242: procedure transfer_entry_os(
1243: p_rec in out nocopy pay_jp_def_entry_os_v%rowtype,
1244: p_business_group_id in number)
1245: is
1246: --
1247: c_proc constant varchar2(61) := c_package ||'.transfer_entry_os';

Line 1327: p_rec in out nocopy pay_jp_def_entry_os_v%rowtype,

1323: -- -------------------------------------------------------------------------
1324: -- rollback_entry_os
1325: -- -------------------------------------------------------------------------
1326: procedure rollback_entry_os(
1327: p_rec in out nocopy pay_jp_def_entry_os_v%rowtype,
1328: p_business_group_id in number)
1329: is
1330: --
1331: c_proc constant varchar2(61) := c_package || '.rollback_entry_os';

Line 1792: l_entry_os_rec pay_jp_def_entry_os_v%rowtype;

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;
1795: l_csr_household_head csr_household_head%rowtype;
1796: l_csr_married_flag csr_married_flag%rowtype;

Line 2378: l_entry_os_rec pay_jp_def_entry_os_v%rowtype;

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: --
2381: cursor csr_entry(p_assignment_action_id in number)
2382: is

Line 2398: from pay_jp_def_entry_os_v

2394: --
2395: cursor csr_entry_os(p_assignment_action_id in number)
2396: is
2397: select *
2398: from pay_jp_def_entry_os_v
2399: where assignment_action_id = p_assignment_action_id
2400: for update nowait;
2401: --
2402: cursor csr_emp(p_assignment_action_id in number)

Line 2918: from pay_jp_def_entry_os_v

2914: --
2915: cursor csr_entry_os(p_assignment_action_id number)
2916: is
2917: select *
2918: from pay_jp_def_entry_os_v
2919: where assignment_action_id = p_assignment_action_id
2920: for update nowait;
2921: --
2922: --

Line 3252: l_entry_os_rec pay_jp_def_entry_os_v%rowtype;

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;
3255: l_dep_os_rec pay_jp_def_dep_os_v%rowtype;
3256: --

Line 3274: from pay_jp_def_entry_os_v

3270: --
3271: cursor csr_entry_os(p_assignment_action_id number)
3272: is
3273: select *
3274: from pay_jp_def_entry_os_v
3275: where assignment_action_id = p_assignment_action_id
3276: for update nowait;
3277: --
3278: --

Line 3552: from pay_jp_def_entry_os_v v

3548: --
3549: cursor csr_entry_os(p_assignment_action_id number)
3550: is
3551: select v.*
3552: from pay_jp_def_entry_os_v v
3553: where v.assignment_action_id = p_assignment_action_id
3554: and exists(
3555: select null
3556: from pay_element_entries_f pee

Line 3822: from pay_jp_def_entry_os_v v

3818: p_assignment_action_id number,
3819: p_expiry_date date)
3820: is
3821: select v.*
3822: from pay_jp_def_entry_os_v v
3823: where v.assignment_action_id = p_assignment_action_id
3824: and exists(
3825: select null
3826: from pay_element_entries_f pee