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_CA_FF_UDFS dependencies on HR_LOOKUPS

Line 225: hr_lookups HRL

221: NVL(SCL.segment4, 'NOT ENTERED')
222: FROM per_assignments_f ASG,
223: per_assignment_status_types AST,
224: hr_soft_coding_keyflex SCL,
225: hr_lookups HRL
226: WHERE ASG.assignment_id = p_asst_id
227: AND ASG.business_group_id + 0 = p_bus_grp_id
228: AND ASG.effective_start_date > p_period_start
229: AND ASG.effective_end_date <= p_period_end

Line 728: hr_lookups FCL

724: v_pay_basis,
725: v_pay_basis_code
726: FROM per_assignments_f ASG,
727: per_pay_bases PYB,
728: hr_lookups FCL
729: WHERE FCL.lookup_code = PYB.pay_basis
730: AND FCL.lookup_type = 'PAY_BASIS'
731: AND FCL.application_id = 800
732: AND PYB.pay_basis_id = ASG.pay_basis_id

Line 1307: hr_lookups HRL

1303: v_work_schedule
1304: FROM per_assignments_f ASG,
1305: per_assignment_status_types AST,
1306: hr_soft_coding_keyflex SCL,
1307: hr_lookups HRL
1308: WHERE ASG.assignment_id = p_asst_id
1309: AND ASG.business_group_id + 0 = p_bus_grp_id
1310: AND ASG.effective_start_date <= p_period_start
1311: AND ASG.effective_end_date >= p_period_start

Line 1425: hr_lookups HRL

1421: v_work_schedule
1422: FROM hr_soft_coding_keyflex SCL,
1423: per_assignment_status_types AST,
1424: per_assignments_f ASG,
1425: hr_lookups HRL
1426: WHERE ASG.assignment_id = p_asst_id
1427: AND ASG.business_group_id + 0 = p_bus_grp_id
1428: AND ASG.effective_start_date > p_period_start
1429: AND ASG.effective_start_date <= p_period_end

Line 1560: hr_lookups HRL

1556: v_work_schedule
1557: FROM per_assignments_f ASG,
1558: per_assignment_status_types AST,
1559: hr_soft_coding_keyflex SCL,
1560: hr_lookups HRL
1561: WHERE ASG.assignment_id = p_asst_id
1562: AND ASG.business_group_id + 0 = p_bus_grp_id
1563: AND ASG.effective_start_date <= p_period_start
1564: AND ASG.effective_end_date >= p_period_start

Line 1814: hr_lookups HRL

1810: v_work_schedule
1811: FROM hr_soft_coding_keyflex SCL,
1812: per_assignment_status_types AST,
1813: per_assignments_f ASG,
1814: hr_lookups HRL
1815: WHERE ASG.assignment_id = p_asst_id
1816: AND ASG.business_group_id + 0 = p_bus_grp_id
1817: AND ASG.effective_start_date > p_period_start
1818: AND ASG.effective_start_date <= p_period_end

Line 2096: FROM hr_lookups lkp

2092: hr_utility.set_location('Get_Annualizing_Factor', 13);
2093:
2094: SELECT lookup_code
2095: INTO v_pay_basis
2096: FROM hr_lookups lkp
2097: WHERE lkp.application_id = 800
2098: AND lkp.lookup_type = 'PAY_BASIS'
2099: AND lkp.lookup_code = p_freq;
2100: