DBA Data[Home] [Help]

APPS.PQP_GB_AD_EE dependencies on PAY_PAYE_ELEMENT_ENTRIES_V

Line 1843: FROM pay_paye_element_entries_v pev,

1839: IS
1840: SELECT pev.element_entry_id,
1841: paf.assignment_id
1842: , pev.effective_start_date --10157179
1843: FROM pay_paye_element_entries_v pev,
1844: per_all_assignments_f paf,
1845: per_assignment_status_types past
1846: WHERE pev.assignment_id = paf.assignment_id
1847: AND past.assignment_status_type_id = paf.assignment_status_type_id

Line 1878: FROM pay_paye_element_entries_v

1874: input_value_id6,
1875: d_authority,
1876: entry_information1, -- For bug 8548190
1877: entry_information2
1878: FROM pay_paye_element_entries_v
1879: WHERE element_entry_id = p_element_entry_id
1880: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1881:
1882: --Added the below cursor for the bug fix# 10254292

Line 2130: /*SESSION Date should be present for the view pay_paye_element_entries_v

2126: CLOSE c_get_input_values;
2127:
2128: hr_utility.set_location('PAYE l_tax_code :'||l_tax_code ,18);
2129: --10157179 Begin
2130: /*SESSION Date should be present for the view pay_paye_element_entries_v
2131: used in cursor cur_element_entry_id. */
2132: select count(*) into l_session_present from fnd_sessions ses
2133: where ses.session_id = userenv('SESSIONID');
2134: If l_session_present <> 1 then