APPS.PAY_CORE_FF_UDFS dependencies on HR_LOOKUPS

Line 436: FROM hr_lookups lkp

432: RETURN NUMBER IS
433:
434: CURSOR c_get_lookupcode_freq IS
435: SELECT lookup_code
436: FROM hr_lookups lkp
437: WHERE lkp.application_id = 800
438: AND lkp.lookup_type = 'PAY_BASIS'
439: AND lkp.lookup_code = p_freq;
440:

Line 443: FROM hr_lookups lkp

439: AND lkp.lookup_code = p_freq;
440:
441: CURSOR c_get_lookupmeaning_freq IS
442: SELECT lookup_code
443: FROM hr_lookups lkp
444: WHERE lkp.application_id = 800
445: AND lkp.lookup_type = 'PAY_BASIS'
446: AND lkp.meaning = p_freq;
447:

Line 1170: hr_lookups HRL

1166: NVL(SCL.segment4, 'NOT ENTERED')
1167: FROM per_assignments_f ASG,
1168: per_assignment_status_types AST,
1169: hr_soft_coding_keyflex SCL,
1170: hr_lookups HRL
1171: WHERE ASG.assignment_id = p_asst_id
1172: AND ASG.business_group_id + 0 = p_bus_grp_id
1173: AND ASG.effective_start_date > p_period_start
1174: AND ASG.effective_end_date <= p_period_end

Line 1790: hr_lookups FCL

1786: INTO v_inpval_id,
1787: v_pay_basis
1788: FROM per_assignments_f ASG,
1789: per_pay_bases PYB,
1790: hr_lookups FCL
1791: WHERE FCL.lookup_code = PYB.pay_basis
1792: AND FCL.lookup_type = 'PAY_BASIS'
1793: AND FCL.application_id = 800
1794: AND PYB.pay_basis_id = ASG.pay_basis_id

Line 2406: hr_lookups HRL

2402: v_work_schedule
2403: FROM per_assignments_f ASG,
2404: per_assignment_status_types AST,
2405: hr_soft_coding_keyflex SCL,
2406: hr_lookups HRL
2407: WHERE ASG.assignment_id = p_asst_id
2408: AND ASG.business_group_id + 0 = p_bus_grp_id
2409: AND ASG.effective_start_date <= p_period_start
2410: AND ASG.effective_end_date >= p_period_start

Line 2491: hr_lookups HRL

2487: v_work_schedule
2488: FROM hr_soft_coding_keyflex SCL,
2489: per_assignment_status_types AST,
2490: per_assignments_f ASG,
2491: hr_lookups HRL
2492: WHERE ASG.assignment_id = p_asst_id
2493: AND ASG.business_group_id + 0 = p_bus_grp_id
2494: AND ASG.effective_start_date > p_period_start
2495: AND ASG.effective_start_date <= p_period_end

Line 2649: hr_lookups HRL

2645: v_work_schedule
2646: FROM per_assignments_f ASG,
2647: per_assignment_status_types AST,
2648: hr_soft_coding_keyflex SCL,
2649: hr_lookups HRL
2650: WHERE ASG.assignment_id = p_asst_id
2651: AND ASG.business_group_id + 0 = p_bus_grp_id
2652: AND ASG.effective_start_date <= p_period_start
2653: AND ASG.effective_end_date >= p_period_start

Line 2891: hr_lookups HRL

2887: v_work_schedule
2888: FROM hr_soft_coding_keyflex SCL,
2889: per_assignment_status_types AST,
2890: per_assignments_f ASG,
2891: hr_lookups HRL
2892: WHERE ASG.assignment_id = p_asst_id
2893: AND ASG.business_group_id + 0 = p_bus_grp_id
2894: AND ASG.effective_start_date > p_period_start
2895: AND ASG.effective_start_date <= p_period_end