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_GB_T1_PENSION_EXTRACTS dependencies on FND_DATE

Line 2023: and fnd_date.canonical_to_date(process.result_value) between

2019: and process.input_value_id = process_iv.input_value_id
2020: and process_iv.name = 'Date Worked'
2021: and PACT.effective_date between
2022: process_iv.effective_start_date and process_iv.effective_end_date
2023: and fnd_date.canonical_to_date(process.result_value) between
2024: p_start_date and p_end_date;
2025:
2026: CURSOR csr_get_supp_ded(p_bal_type_id NUMBER,
2027: p_assignment_id NUMBER,

Line 2058: and fnd_date.canonical_to_date(process.result_value) not between

2054: and process.input_value_id = process_iv.input_value_id
2055: and process_iv.name = 'Date Worked'
2056: and PACT.effective_date between
2057: process_iv.effective_start_date and process_iv.effective_end_date
2058: and fnd_date.canonical_to_date(process.result_value) not between
2059: p_start_date and p_end_date;
2060:
2061: CURSOR csr_is_supp_claim(p_run_result_id NUMBER, -- changed for bug 7278398
2062: p_start_date DATE,

Line 2089: AND fnd_date.canonical_to_date(process.result_value) not between

2085: p_end_date between process_iv.effective_start_date
2086: and process_iv.effective_end_date
2087: )
2088: and process_iv.effective_start_date between pet.effective_start_date and pet.effective_end_date
2089: AND fnd_date.canonical_to_date(process.result_value) not between
2090: p_start_date and p_end_date;
2091:
2092:
2093: -- added for 5743209