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 2791: FROM pay_user_column_instances_f inst1

2787: ,p_user_row_id IN NUMBER
2788: )
2789: IS
2790: SELECT inst2.effective_start_date
2791: FROM pay_user_column_instances_f inst1
2792: ,pay_user_column_instances_f inst2
2793: WHERE ( inst1.effective_start_date >= p_effective_start_date
2794: OR p_effective_start_date BETWEEN inst1.effective_start_date
2795: AND inst1.effective_end_date

Line 2792: ,pay_user_column_instances_f inst2

2788: )
2789: IS
2790: SELECT inst2.effective_start_date
2791: FROM pay_user_column_instances_f inst1
2792: ,pay_user_column_instances_f inst2
2793: WHERE ( inst1.effective_start_date >= p_effective_start_date
2794: OR p_effective_start_date BETWEEN inst1.effective_start_date
2795: AND inst1.effective_end_date
2796: )

Line 2837: FROM pay_user_column_instances_f inst1

2833: AND NVL(aat2.contract_type, '{null}') <>
2834: NVL(aat1.contract_type, '[NULL]')
2835: UNION ALL
2836: SELECT inst2.effective_start_date
2837: FROM pay_user_column_instances_f inst1
2838: ,pay_user_column_instances_f inst2
2839: WHERE ( inst1.effective_start_date >= p_effective_start_date
2840: OR p_effective_start_date BETWEEN inst1.effective_start_date
2841: AND inst1.effective_end_date

Line 2838: ,pay_user_column_instances_f inst2

2834: NVL(aat1.contract_type, '[NULL]')
2835: UNION ALL
2836: SELECT inst2.effective_start_date
2837: FROM pay_user_column_instances_f inst1
2838: ,pay_user_column_instances_f inst2
2839: WHERE ( inst1.effective_start_date >= p_effective_start_date
2840: OR p_effective_start_date BETWEEN inst1.effective_start_date
2841: AND inst1.effective_end_date
2842: )