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.

[Home] [Help]

APPS.HR_CA_FF_UDFS dependencies on HR_LOOKUPS

Line 219: hr_lookups HRL

215: NVL(SCL.segment4, 'NOT ENTERED')
216: FROM per_assignments_f ASG,
217: per_assignment_status_types AST,
218: hr_soft_coding_keyflex SCL,
219: hr_lookups HRL
220: WHERE ASG.assignment_id = p_asst_id
221: AND ASG.business_group_id + 0 = p_bus_grp_id
222: AND ASG.effective_start_date > p_period_start
223: AND ASG.effective_end_date <= p_period_end

Line 722: hr_lookups FCL

718: v_pay_basis,
719: v_pay_basis_code
720: FROM per_assignments_f ASG,
721: per_pay_bases PYB,
722: hr_lookups FCL
723: WHERE FCL.lookup_code = PYB.pay_basis
724: AND FCL.lookup_type = 'PAY_BASIS'
725: AND FCL.application_id = 800
726: AND PYB.pay_basis_id = ASG.pay_basis_id

Line 1270: hr_lookups HRL

1266: v_work_schedule
1267: FROM per_assignments_f ASG,
1268: per_assignment_status_types AST,
1269: hr_soft_coding_keyflex SCL,
1270: hr_lookups HRL
1271: WHERE ASG.assignment_id = p_asst_id
1272: AND ASG.business_group_id + 0 = p_bus_grp_id
1273: AND ASG.effective_start_date <= p_period_start
1274: AND ASG.effective_end_date >= p_period_start

Line 1388: hr_lookups HRL

1384: v_work_schedule
1385: FROM hr_soft_coding_keyflex SCL,
1386: per_assignment_status_types AST,
1387: per_assignments_f ASG,
1388: hr_lookups HRL
1389: WHERE ASG.assignment_id = p_asst_id
1390: AND ASG.business_group_id + 0 = p_bus_grp_id
1391: AND ASG.effective_start_date > p_period_start
1392: AND ASG.effective_start_date <= p_period_end

Line 1523: hr_lookups HRL

1519: v_work_schedule
1520: FROM per_assignments_f ASG,
1521: per_assignment_status_types AST,
1522: hr_soft_coding_keyflex SCL,
1523: hr_lookups HRL
1524: WHERE ASG.assignment_id = p_asst_id
1525: AND ASG.business_group_id + 0 = p_bus_grp_id
1526: AND ASG.effective_start_date <= p_period_start
1527: AND ASG.effective_end_date >= p_period_start

Line 1777: hr_lookups HRL

1773: v_work_schedule
1774: FROM hr_soft_coding_keyflex SCL,
1775: per_assignment_status_types AST,
1776: per_assignments_f ASG,
1777: hr_lookups HRL
1778: WHERE ASG.assignment_id = p_asst_id
1779: AND ASG.business_group_id + 0 = p_bus_grp_id
1780: AND ASG.effective_start_date > p_period_start
1781: AND ASG.effective_start_date <= p_period_end

Line 2059: FROM hr_lookups lkp

2055: hr_utility.set_location('Get_Annualizing_Factor', 13);
2056:
2057: SELECT lookup_code
2058: INTO v_pay_basis
2059: FROM hr_lookups lkp
2060: WHERE lkp.application_id = 800
2061: AND lkp.lookup_type = 'PAY_BASIS'
2062: AND lkp.lookup_code = p_freq;
2063: