eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_US_FF_UDFS dependencies on HR_LOOKUPS

Line 495: hr_lookups HRL

491: NVL(SCL.segment4, 'NOT ENTERED')
492: FROM per_assignments_f ASG,
493: per_assignment_status_types AST,
494: hr_soft_coding_keyflex SCL,
495: hr_lookups HRL
496: WHERE ASG.assignment_id = p_asst_id
497: AND ASG.business_group_id + 0 = p_bus_grp_id
498: AND ASG.effective_start_date > p_period_start
499: AND ASG.effective_end_date <= p_period_end

Line 1048: hr_lookups FCL

1044: INTO v_inpval_id,
1045: v_pay_basis
1046: FROM per_assignments_f ASG,
1047: per_pay_bases PYB,
1048: hr_lookups FCL
1049: WHERE FCL.lookup_code = PYB.pay_basis
1050: AND FCL.lookup_type = 'PAY_BASIS'
1051: AND FCL.application_id = 800
1052: AND PYB.pay_basis_id = ASG.pay_basis_id

Line 1604: hr_lookups HRL

1600: v_work_schedule
1601: FROM per_assignments_f ASG,
1602: per_assignment_status_types AST,
1603: hr_soft_coding_keyflex SCL,
1604: hr_lookups HRL
1605: WHERE ASG.assignment_id = p_asst_id
1606: AND ASG.business_group_id + 0 = p_bus_grp_id
1607: AND ASG.effective_start_date <= p_period_start
1608: AND ASG.effective_end_date >= p_period_start

Line 1695: hr_lookups HRL

1691: v_work_schedule
1692: FROM hr_soft_coding_keyflex SCL,
1693: per_assignment_status_types AST,
1694: per_assignments_f ASG,
1695: hr_lookups HRL
1696: WHERE ASG.assignment_id = p_asst_id
1697: AND ASG.business_group_id + 0 = p_bus_grp_id
1698: AND ASG.effective_start_date > p_period_start
1699: AND ASG.effective_start_date <= p_period_end

Line 1859: hr_lookups HRL

1855: v_work_schedule
1856: FROM per_assignments_f ASG,
1857: per_assignment_status_types AST,
1858: hr_soft_coding_keyflex SCL,
1859: hr_lookups HRL
1860: WHERE ASG.assignment_id = p_asst_id
1861: AND ASG.business_group_id + 0 = p_bus_grp_id
1862: AND ASG.effective_start_date <= p_period_start
1863: AND ASG.effective_end_date >= p_period_start

Line 2080: hr_lookups HRL

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

Line 2407: FROM hr_lookups lkp

2403: hr_utility.trace(' p_freq ='||p_freq);
2404:
2405: SELECT lookup_code
2406: INTO v_pay_basis
2407: FROM hr_lookups lkp
2408: WHERE lkp.application_id = 800
2409: AND lkp.lookup_type = 'PAY_BASIS'
2410: AND lkp.meaning = p_freq;
2411: