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 1168: per_assignment_status_types AST,

1164: NVL(ASG.normal_hours, 0),
1165: NVL(HRL.meaning, 'NOT ENTERED'),
1166: NVL(SCL.segment4, 'NOT ENTERED')
1167: FROM per_assignments_f ASG,
1168: per_assignment_status_types AST,
1169: hr_soft_coding_keyflex SCL,
1170: hr_lookups HRL
1171: WHERE ASG.assignment_id = p_asst_id
1172: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 2136: per_assignment_status_types AST,

2132: from dual
2133: where exists (
2134: SELECT 1
2135: FROM per_assignments_f ASG,
2136: per_assignment_status_types AST,
2137: hr_soft_coding_keyflex SCL
2138: WHERE ASG.assignment_id = p_asst_id
2139: AND ASG.effective_start_date <= p_period_start
2140: AND ASG.effective_end_date >= p_period_start

Line 2209: per_assignment_status_types AST,

2205: from dual
2206: where exists (
2207: SELECT 1
2208: FROM per_assignments_f ASG,
2209: per_assignment_status_types AST,
2210: hr_soft_coding_keyflex SCL
2211: WHERE ASG.assignment_id = p_asst_id
2212: AND ASG.effective_start_date > p_period_start
2213: AND ASG.effective_start_date <= p_period_end

Line 2331: per_assignment_status_types AST,

2327:
2328: SELECT AST.per_system_status
2329: INTO v_asg_status
2330: FROM per_assignments_f ASG,
2331: per_assignment_status_types AST,
2332: hr_soft_coding_keyflex SCL
2333: WHERE ASG.assignment_id = p_asst_id
2334: AND p_period_start BETWEEN ASG.effective_start_date
2335: AND ASG.effective_end_date

Line 2404: per_assignment_status_types AST,

2400: v_asst_std_hrs,
2401: v_asst_std_freq,
2402: v_work_schedule
2403: FROM per_assignments_f ASG,
2404: per_assignment_status_types AST,
2405: hr_soft_coding_keyflex SCL,
2406: hr_lookups HRL
2407: WHERE ASG.assignment_id = p_asst_id
2408: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 2489: per_assignment_status_types AST,

2485: v_asst_std_hrs,
2486: v_asst_std_freq,
2487: v_work_schedule
2488: FROM hr_soft_coding_keyflex SCL,
2489: per_assignment_status_types AST,
2490: per_assignments_f ASG,
2491: hr_lookups HRL
2492: WHERE ASG.assignment_id = p_asst_id
2493: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 2647: per_assignment_status_types AST,

2643: v_asst_std_hrs,
2644: v_asst_std_freq,
2645: v_work_schedule
2646: FROM per_assignments_f ASG,
2647: per_assignment_status_types AST,
2648: hr_soft_coding_keyflex SCL,
2649: hr_lookups HRL
2650: WHERE ASG.assignment_id = p_asst_id
2651: AND ASG.business_group_id + 0 = p_bus_grp_id

Line 2889: per_assignment_status_types AST,

2885: v_asst_std_hrs,
2886: v_asst_std_freq,
2887: v_work_schedule
2888: FROM hr_soft_coding_keyflex SCL,
2889: per_assignment_status_types AST,
2890: per_assignments_f ASG,
2891: hr_lookups HRL
2892: WHERE ASG.assignment_id = p_asst_id
2893: AND ASG.business_group_id + 0 = p_bus_grp_id