APPS.HR_NL_EXTRA_ASG_RULES dependencies on HR_LOOKUPS

Line 43: l_lookup_desc hr_lookups.meaning%TYPE;

39: l_2_digit VARCHAR2(1);
40: l_3_digit VARCHAR2(1);
41: l_valid BOOLEAN;
42: l_mar_status per_all_people_f.marital_status%TYPE;
43: l_lookup_desc hr_lookups.meaning%TYPE;
44: l_age NUMBER;
45: l_tax_code VARCHAR2(60);
46: l_tax_red_apply VARCHAR2(60);
47: l_labour_tax_apply VARCHAR2(60);

Line 69: FROM hr_lookups

65: AND effective_end_date;
66: --
67: CURSOR csr_get_lookup_desc(p_lookup_code VARCHAR2) IS
68: SELECT UPPER(description)
69: FROM hr_lookups
70: WHERE lookup_type ='MAR_STATUS'
71: AND lookup_code = p_lookup_code;
72:
73: CURSOR csr_get_asg_tax_details (p_assignment_id NUMBER

Line 310: FROM hr_lookups

306: --
307: CURSOR csr_lookup_code_exists(p_lookup_type VARCHAR2
308: ,p_lookup_code VARCHAR2) IS
309: SELECT '1'
310: FROM hr_lookups
311: WHERE lookup_code = p_lookup_code
312: AND lookup_type = p_lookup_type;
313:
314: --

Line 441: FROM hr_lookups

437: --
438: CURSOR csr_lookup_code_exists(p_lookup_type VARCHAR2
439: ,p_lookup_code VARCHAR2) IS
440: SELECT '1'
441: FROM hr_lookups
442: WHERE lookup_code = p_lookup_code
443: AND lookup_type = p_lookup_type;
444: --
445: l_lookup_type hr_lookups.lookup_type%TYPE;

Line 445: l_lookup_type hr_lookups.lookup_type%TYPE;

441: FROM hr_lookups
442: WHERE lookup_code = p_lookup_code
443: AND lookup_type = p_lookup_type;
444: --
445: l_lookup_type hr_lookups.lookup_type%TYPE;
446: l_exists VARCHAR2(30);
447:
448:
449: CURSOR csr_get_asg_oth_details (p_assignment_id NUMBER