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.PQP_FTE_UTILITIES dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 21: ,annual_hours pay_user_column_instances_f.value%TYPE

17: ,FTE_new_value per_assignment_budget_values_f.value%TYPE
18: ,normal_hours per_all_assignments_f.normal_hours%TYPE
19: ,frequency per_all_assignments_f.frequency%TYPE
20: ,contract_type pqp_assignment_attributes_f.contract_type%TYPE
21: ,annual_hours pay_user_column_instances_f.value%TYPE
22: ,period_divisor pay_user_column_instances_f.value%TYPE
23: ,message fnd_new_messages.message_text%TYPE
24: );
25: TYPE t_output_file_record_type IS TABLE OF g_output_file_rec_type

Line 22: ,period_divisor pay_user_column_instances_f.value%TYPE

18: ,normal_hours per_all_assignments_f.normal_hours%TYPE
19: ,frequency per_all_assignments_f.frequency%TYPE
20: ,contract_type pqp_assignment_attributes_f.contract_type%TYPE
21: ,annual_hours pay_user_column_instances_f.value%TYPE
22: ,period_divisor pay_user_column_instances_f.value%TYPE
23: ,message fnd_new_messages.message_text%TYPE
24: );
25: TYPE t_output_file_record_type IS TABLE OF g_output_file_rec_type
26: INDEX BY BINARY_INTEGER;

Line 128: FROM pay_user_column_instances_f inst

124: ,p_contract_row_id NUMBER
125: ,p_effective_date DATE
126: ) IS
127: SELECT inst.value
128: FROM pay_user_column_instances_f inst
129: WHERE inst.user_column_id = p_contract_column_id
130: AND inst.user_row_id = p_contract_row_id
131: AND p_effective_date
132: BETWEEN inst.effective_start_date

Line 1712: ,pay_user_column_instances_f inst1

1708: UNION ALL
1709: SELECT 'Contract Type' change_type,inst2.effective_start_date
1710: FROM pqp_assignment_attributes_f aat
1711: ,pay_user_rows_f pur
1712: ,pay_user_column_instances_f inst1
1713: ,pay_user_column_instances_f inst2
1714: WHERE aat.assignment_id = p_assignment_id
1715: AND ( aat.effective_start_date >= p_min_effective_start_date
1716: OR

Line 1713: ,pay_user_column_instances_f inst2

1709: SELECT 'Contract Type' change_type,inst2.effective_start_date
1710: FROM pqp_assignment_attributes_f aat
1711: ,pay_user_rows_f pur
1712: ,pay_user_column_instances_f inst1
1713: ,pay_user_column_instances_f inst2
1714: WHERE aat.assignment_id = p_assignment_id
1715: AND ( aat.effective_start_date >= p_min_effective_start_date
1716: OR
1717: p_min_effective_start_date