DBA Data[Home] [Help]

APPS.PER_JP_CTR_UTILITY_PKG dependencies on HR_LOOKUPS

Line 9: itax_type hr_lookups.lookup_code%TYPE,

5: --
6: type t_varchar2_tbl is table of varchar2(255) index by binary_integer;
7: type t_itax_dpnt_rec is record(
8: assignment_id number,
9: itax_type hr_lookups.lookup_code%TYPE,
10: effective_date date,
11: spouse_type hr_lookups.lookup_code%TYPE := '0',
12: dpnt_spouse_dsbl_type hr_lookups.lookup_code%TYPE := '0',
13: dpnts number := 0,

Line 11: spouse_type hr_lookups.lookup_code%TYPE := '0',

7: type t_itax_dpnt_rec is record(
8: assignment_id number,
9: itax_type hr_lookups.lookup_code%TYPE,
10: effective_date date,
11: spouse_type hr_lookups.lookup_code%TYPE := '0',
12: dpnt_spouse_dsbl_type hr_lookups.lookup_code%TYPE := '0',
13: dpnts number := 0,
14: aged_dpnts number := 0,
15: aged_dpnt_parents_lt number := 0,

Line 12: dpnt_spouse_dsbl_type hr_lookups.lookup_code%TYPE := '0',

8: assignment_id number,
9: itax_type hr_lookups.lookup_code%TYPE,
10: effective_date date,
11: spouse_type hr_lookups.lookup_code%TYPE := '0',
12: dpnt_spouse_dsbl_type hr_lookups.lookup_code%TYPE := '0',
13: dpnts number := 0,
14: aged_dpnts number := 0,
15: aged_dpnt_parents_lt number := 0,
16: young_dpnts number := 0,

Line 22: dpnt_spouse_type hr_lookups.lookup_code%TYPE := '0',

18: dsbl_dpnts number := 0,
19: svr_dsbl_dpnts number := 0,
20: svr_dsbl_dpnts_lt number := 0,
21: /*
22: dpnt_spouse_type hr_lookups.lookup_code%TYPE := '0',
23: dpnt_spouse_dsbl_type hr_lookups.lookup_code%TYPE := '0',
24: dpnts number := 0,
25: aged_dpnts number := 0,
26: cohab_aged_asc_dpnts number := 0,

Line 23: dpnt_spouse_dsbl_type hr_lookups.lookup_code%TYPE := '0',

19: svr_dsbl_dpnts number := 0,
20: svr_dsbl_dpnts_lt number := 0,
21: /*
22: dpnt_spouse_type hr_lookups.lookup_code%TYPE := '0',
23: dpnt_spouse_dsbl_type hr_lookups.lookup_code%TYPE := '0',
24: dpnts number := 0,
25: aged_dpnts number := 0,
26: cohab_aged_asc_dpnts number := 0,
27: major_dpnts number := 0,