APPS.PAY_CORE_FF_UDFS dependencies on HR_LOOKUPS

Line 158: FROM hr_lookups lkp

154: RETURN NUMBER IS
155:
156: CURSOR c_get_lookupcode_freq IS
157: SELECT lookup_code
158: FROM hr_lookups lkp
159: WHERE lkp.application_id = 800
160: AND lkp.lookup_type = 'PAY_BASIS'
161: AND lkp.lookup_code = p_freq;
162:

Line 165: FROM hr_lookups lkp

161: AND lkp.lookup_code = p_freq;
162:
163: CURSOR c_get_lookupmeaning_freq IS
164: SELECT lookup_code
165: FROM hr_lookups lkp
166: WHERE lkp.application_id = 800
167: AND lkp.lookup_type = 'PAY_BASIS'
168: AND lkp.meaning = p_freq;
169:

Line 791: hr_lookups HRL

787: NVL(SCL.segment4, 'NOT ENTERED')
788: FROM per_assignments_f ASG,
789: per_assignment_status_types AST,
790: hr_soft_coding_keyflex SCL,
791: hr_lookups HRL
792: WHERE ASG.assignment_id = p_asst_id
793: AND ASG.business_group_id + 0 = p_bus_grp_id
794: AND ASG.effective_start_date > p_period_start
795: AND ASG.effective_end_date <= p_period_end

Line 1411: hr_lookups FCL

1407: INTO v_inpval_id,
1408: v_pay_basis
1409: FROM per_assignments_f ASG,
1410: per_pay_bases PYB,
1411: hr_lookups FCL
1412: WHERE FCL.lookup_code = PYB.pay_basis
1413: AND FCL.lookup_type = 'PAY_BASIS'
1414: AND FCL.application_id = 800
1415: AND PYB.pay_basis_id = ASG.pay_basis_id

Line 1997: hr_lookups HRL

1993: v_work_schedule
1994: FROM per_assignments_f ASG,
1995: per_assignment_status_types AST,
1996: hr_soft_coding_keyflex SCL,
1997: hr_lookups HRL
1998: WHERE ASG.assignment_id = p_asst_id
1999: AND ASG.business_group_id + 0 = p_bus_grp_id
2000: AND ASG.effective_start_date <= p_period_start
2001: AND ASG.effective_end_date >= p_period_start

Line 2082: hr_lookups HRL

2078: v_work_schedule
2079: FROM hr_soft_coding_keyflex SCL,
2080: per_assignment_status_types AST,
2081: per_assignments_f ASG,
2082: hr_lookups HRL
2083: WHERE ASG.assignment_id = p_asst_id
2084: AND ASG.business_group_id + 0 = p_bus_grp_id
2085: AND ASG.effective_start_date > p_period_start
2086: AND ASG.effective_start_date <= p_period_end

Line 2240: hr_lookups HRL

2236: v_work_schedule
2237: FROM per_assignments_f ASG,
2238: per_assignment_status_types AST,
2239: hr_soft_coding_keyflex SCL,
2240: hr_lookups HRL
2241: WHERE ASG.assignment_id = p_asst_id
2242: AND ASG.business_group_id + 0 = p_bus_grp_id
2243: AND ASG.effective_start_date <= p_period_start
2244: AND ASG.effective_end_date >= p_period_start

Line 2482: hr_lookups HRL

2478: v_work_schedule
2479: FROM hr_soft_coding_keyflex SCL,
2480: per_assignment_status_types AST,
2481: per_assignments_f ASG,
2482: hr_lookups HRL
2483: WHERE ASG.assignment_id = p_asst_id
2484: AND ASG.business_group_id + 0 = p_bus_grp_id
2485: AND ASG.effective_start_date > p_period_start
2486: AND ASG.effective_start_date <= p_period_end