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_BUDGET_MAINTENANCE dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 2833: FROM pay_user_column_instances_f inst1

2829: ,p_user_row_id IN NUMBER
2830: )
2831: IS
2832: SELECT inst2.effective_start_date
2833: FROM pay_user_column_instances_f inst1
2834: ,pay_user_column_instances_f inst2
2835: WHERE ( inst1.effective_start_date >= p_effective_start_date
2836: OR p_effective_start_date BETWEEN inst1.effective_start_date
2837: AND inst1.effective_end_date

Line 2834: ,pay_user_column_instances_f inst2

2830: )
2831: IS
2832: SELECT inst2.effective_start_date
2833: FROM pay_user_column_instances_f inst1
2834: ,pay_user_column_instances_f inst2
2835: WHERE ( inst1.effective_start_date >= p_effective_start_date
2836: OR p_effective_start_date BETWEEN inst1.effective_start_date
2837: AND inst1.effective_end_date
2838: )

Line 2879: FROM pay_user_column_instances_f inst1

2875: AND NVL(aat2.contract_type, '{null}') <>
2876: NVL(aat1.contract_type, '[NULL]')
2877: UNION ALL
2878: SELECT inst2.effective_start_date
2879: FROM pay_user_column_instances_f inst1
2880: ,pay_user_column_instances_f inst2
2881: WHERE ( inst1.effective_start_date >= p_effective_start_date
2882: OR p_effective_start_date BETWEEN inst1.effective_start_date
2883: AND inst1.effective_end_date

Line 2880: ,pay_user_column_instances_f inst2

2876: NVL(aat1.contract_type, '[NULL]')
2877: UNION ALL
2878: SELECT inst2.effective_start_date
2879: FROM pay_user_column_instances_f inst1
2880: ,pay_user_column_instances_f inst2
2881: WHERE ( inst1.effective_start_date >= p_effective_start_date
2882: OR p_effective_start_date BETWEEN inst1.effective_start_date
2883: AND inst1.effective_end_date
2884: )