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

Line 486: hr_lookups HRL

482: NVL(SCL.segment4, 'NOT ENTERED')
483: FROM per_assignments_f ASG,
484: per_assignment_status_types AST,
485: hr_soft_coding_keyflex SCL,
486: hr_lookups HRL
487: WHERE ASG.assignment_id = p_asst_id
488: AND ASG.business_group_id + 0 = p_bus_grp_id
489: AND ASG.effective_start_date > p_period_start
490: AND ASG.effective_end_date <= p_period_end

Line 1039: hr_lookups FCL

1035: INTO v_inpval_id,
1036: v_pay_basis
1037: FROM per_assignments_f ASG,
1038: per_pay_bases PYB,
1039: hr_lookups FCL
1040: WHERE FCL.lookup_code = PYB.pay_basis
1041: AND FCL.lookup_type = 'PAY_BASIS'
1042: AND FCL.application_id = 800
1043: AND PYB.pay_basis_id = ASG.pay_basis_id

Line 1595: hr_lookups HRL

1591: v_work_schedule
1592: FROM per_assignments_f ASG,
1593: per_assignment_status_types AST,
1594: hr_soft_coding_keyflex SCL,
1595: hr_lookups HRL
1596: WHERE ASG.assignment_id = p_asst_id
1597: AND ASG.business_group_id + 0 = p_bus_grp_id
1598: AND ASG.effective_start_date <= p_period_start
1599: AND ASG.effective_end_date >= p_period_start

Line 1686: hr_lookups HRL

1682: v_work_schedule
1683: FROM hr_soft_coding_keyflex SCL,
1684: per_assignment_status_types AST,
1685: per_assignments_f ASG,
1686: hr_lookups HRL
1687: WHERE ASG.assignment_id = p_asst_id
1688: AND ASG.business_group_id + 0 = p_bus_grp_id
1689: AND ASG.effective_start_date > p_period_start
1690: AND ASG.effective_start_date <= p_period_end

Line 1850: hr_lookups HRL

1846: v_work_schedule
1847: FROM per_assignments_f ASG,
1848: per_assignment_status_types AST,
1849: hr_soft_coding_keyflex SCL,
1850: hr_lookups HRL
1851: WHERE ASG.assignment_id = p_asst_id
1852: AND ASG.business_group_id + 0 = p_bus_grp_id
1853: AND ASG.effective_start_date <= p_period_start
1854: AND ASG.effective_end_date >= p_period_start

Line 2071: hr_lookups HRL

2067: v_work_schedule
2068: FROM hr_soft_coding_keyflex SCL,
2069: per_assignment_status_types AST,
2070: per_assignments_f ASG,
2071: hr_lookups HRL
2072: WHERE ASG.assignment_id = p_asst_id
2073: AND ASG.business_group_id + 0 = p_bus_grp_id
2074: AND ASG.effective_start_date > p_period_start
2075: AND ASG.effective_start_date <= p_period_end

Line 2398: FROM hr_lookups lkp

2394: hr_utility.trace(' p_freq ='||p_freq);
2395:
2396: SELECT lookup_code
2397: INTO v_pay_basis
2398: FROM hr_lookups lkp
2399: WHERE lkp.application_id = 800
2400: AND lkp.lookup_type = 'PAY_BASIS'
2401: AND lkp.meaning = p_freq;
2402: