DBA Data[Home] [Help]

APPS.PAY_JP_DEF_SS dependencies on PAY_JP_DEF_EMP_V

Line 1259: l_emp_rec pay_jp_def_emp_v%rowtype;

1255: p_object_version_number in out nocopy number)
1256: is
1257: c_proc constant varchar2(61) := c_package || 'do_new';
1258: l_assact_rec pay_jp_def_assact_v%rowtype;
1259: l_emp_rec pay_jp_def_emp_v%rowtype;
1260: l_entry_rec pay_jp_def_entry_v%rowtype;
1261: l_person_id number;
1262: l_business_group_id number;
1263: l_contact_person_id number;

Line 1837: l_emp_rec pay_jp_def_emp_v%rowtype;

1833: c_proc constant varchar2(61) := c_package || 'do_finalize';
1834: l_submission_date date;
1835: l_assact_rec pay_jp_def_assact_v%rowtype;
1836: l_entry_rec pay_jp_def_entry_v%rowtype;
1837: l_emp_rec pay_jp_def_emp_v%rowtype;
1838: --
1839: cursor csr_entry(p_assignment_action_id in number) is
1840: select *
1841: from pay_jp_def_entry_v

Line 1846: from pay_jp_def_emp_v

1842: where assignment_action_id = p_assignment_action_id
1843: for update nowait;
1844: cursor csr_emp(p_assignment_action_id in number) is
1845: select *
1846: from pay_jp_def_emp_v
1847: where assignment_action_id = p_assignment_action_id;
1848: cursor csr_dep(p_assignment_action_id in number) is
1849: select *
1850: from pay_jp_def_dep_v