DBA Data[Home] [Help]

APPS.PAY_JP_DEF_SS dependencies on PAY_JP_DEF_EMP_V

Line 1500: l_disability_type pay_jp_def_emp_v.disability_type%type;

1496: --
1497: l_action_information_id number;
1498: l_object_version_number number;
1499: --
1500: l_disability_type pay_jp_def_emp_v.disability_type%type;
1501: l_aged_type pay_jp_def_emp_v.aged_type%type;
1502: l_widow_type pay_jp_def_emp_v.widow_type%type;
1503: l_working_student_type pay_jp_def_emp_v.working_student_type%type;
1504: --

Line 1501: l_aged_type pay_jp_def_emp_v.aged_type%type;

1497: l_action_information_id number;
1498: l_object_version_number number;
1499: --
1500: l_disability_type pay_jp_def_emp_v.disability_type%type;
1501: l_aged_type pay_jp_def_emp_v.aged_type%type;
1502: l_widow_type pay_jp_def_emp_v.widow_type%type;
1503: l_working_student_type pay_jp_def_emp_v.working_student_type%type;
1504: --
1505: l_itax_organization_id number;

Line 1502: l_widow_type pay_jp_def_emp_v.widow_type%type;

1498: l_object_version_number number;
1499: --
1500: l_disability_type pay_jp_def_emp_v.disability_type%type;
1501: l_aged_type pay_jp_def_emp_v.aged_type%type;
1502: l_widow_type pay_jp_def_emp_v.widow_type%type;
1503: l_working_student_type pay_jp_def_emp_v.working_student_type%type;
1504: --
1505: l_itax_organization_id number;
1506: --

Line 1503: l_working_student_type pay_jp_def_emp_v.working_student_type%type;

1499: --
1500: l_disability_type pay_jp_def_emp_v.disability_type%type;
1501: l_aged_type pay_jp_def_emp_v.aged_type%type;
1502: l_widow_type pay_jp_def_emp_v.widow_type%type;
1503: l_working_student_type pay_jp_def_emp_v.working_student_type%type;
1504: --
1505: l_itax_organization_id number;
1506: --
1507: cursor csr_entry

Line 2379: l_emp_rec pay_jp_def_emp_v%rowtype;

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
2383: select *

Line 2405: from pay_jp_def_emp_v

2401: --
2402: cursor csr_emp(p_assignment_action_id in number)
2403: is
2404: select *
2405: from pay_jp_def_emp_v
2406: where assignment_action_id = p_assignment_action_id;
2407: --
2408: cursor csr_dep(p_assignment_action_id in number)
2409: is