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.PAY_CORE_FF_UDFS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 789: per_assignment_status_types AST,

785: NVL(ASG.normal_hours, 0),
786: NVL(HRL.meaning, 'NOT ENTERED'),
787: NVL(SCL.segment4, 'NOT ENTERED')
788: FROM per_assignments_f ASG,
789: per_assignment_status_types AST,
790: hr_soft_coding_keyflex SCL,
791: hr_lookups HRL
792: WHERE ASG.assignment_id = p_asst_id
793: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 1757: per_assignment_status_types AST,

1753: from dual
1754: where exists (
1755: SELECT 1
1756: FROM per_assignments_f ASG,
1757: per_assignment_status_types AST,
1758: hr_soft_coding_keyflex SCL
1759: WHERE ASG.assignment_id = p_asst_id
1760: AND ASG.effective_start_date <= p_period_start
1761: AND ASG.effective_end_date >= p_period_start

Line 1830: per_assignment_status_types AST,

1826: from dual
1827: where exists (
1828: SELECT 1
1829: FROM per_assignments_f ASG,
1830: per_assignment_status_types AST,
1831: hr_soft_coding_keyflex SCL
1832: WHERE ASG.assignment_id = p_asst_id
1833: AND ASG.effective_start_date > p_period_start
1834: AND ASG.effective_start_date <= p_period_end

Line 1924: per_assignment_status_types AST,

1920:
1921: SELECT AST.per_system_status
1922: INTO v_asg_status
1923: FROM per_assignments_f ASG,
1924: per_assignment_status_types AST,
1925: hr_soft_coding_keyflex SCL
1926: WHERE ASG.assignment_id = p_asst_id
1927: AND p_period_start BETWEEN ASG.effective_start_date
1928: AND ASG.effective_end_date

Line 1995: per_assignment_status_types AST,

1991: v_asst_std_hrs,
1992: v_asst_std_freq,
1993: v_work_schedule
1994: FROM per_assignments_f ASG,
1995: per_assignment_status_types AST,
1996: hr_soft_coding_keyflex SCL,
1997: hr_lookups HRL
1998: WHERE ASG.assignment_id = p_asst_id
1999: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 2080: per_assignment_status_types AST,

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

Line 2238: per_assignment_status_types AST,

2234: v_asst_std_hrs,
2235: v_asst_std_freq,
2236: v_work_schedule
2237: FROM per_assignments_f ASG,
2238: per_assignment_status_types AST,
2239: hr_soft_coding_keyflex SCL,
2240: hr_lookups HRL
2241: WHERE ASG.assignment_id = p_asst_id
2242: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 2480: per_assignment_status_types AST,

2476: v_asst_std_hrs,
2477: v_asst_std_freq,
2478: v_work_schedule
2479: FROM hr_soft_coding_keyflex SCL,
2480: per_assignment_status_types AST,
2481: per_assignments_f ASG,
2482: hr_lookups HRL
2483: WHERE ASG.assignment_id = p_asst_id
2484: AND ASG.business_group_id + 0 = p_bus_grp_id