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_AD_EE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 145: pay_element_entry_values_f peev,

141: pay_element_entries_f pee,
142: pay_element_types_f pet,
143: per_all_assignments_f asg,
144: pay_element_type_extra_info pete,
145: pay_element_entry_values_f peev,
146: pay_input_values_f piv
147: WHERE pet.element_type_id = pel.element_type_id
148: AND pel.element_link_id = pee.element_link_id
149: AND pet.element_type_id = pete.element_type_id

Line 277: -- for the table pay_element_entry_values_f

273: AND pete.information_type = 'PQP_VEHICLE_MILEAGE_INFO'
274: AND pete.eei_information1 <>'L';
275:
276: -- Cursor to fetch screen value with check on session_date
277: -- for the table pay_element_entry_values_f
278:
279: CURSOR scr_val_cur( p_name IN VARCHAR2
280: ,p_in_element_entry_id IN NUMBER
281: ) IS

Line 287: pay_element_entry_values_f peev,

283: FROM pay_element_links_f pel,
284: pay_element_entries_f pee,
285: pay_element_types_f pet,
286: pay_element_type_extra_info pete,
287: pay_element_entry_values_f peev,
288: pay_input_values_f piv
289: WHERE pet.element_type_id = pel.element_type_id
290: AND pel.element_link_id = pee.element_link_id
291: AND pet.element_type_id = pete.element_type_id

Line 311: -- for the table pay_element_entry_values_f

307: AND pete.information_type = 'PQP_VEHICLE_MILEAGE_INFO'
308: AND pete.eei_information1 <>'L';
309:
310: -- Cursor to fetch screen for vehicle type with check on session_date
311: -- for the table pay_element_entry_values_f
312:
313: CURSOR vehicle_type_cur(p_in_element_entry_id IN NUMBER
314: ) IS
315: SELECT peev.screen_entry_value

Line 320: pay_element_entry_values_f peev,

316: FROM pay_element_links_f pel,
317: pay_element_entries_f pee,
318: pay_element_types_f pet,
319: pay_element_type_extra_info pete,
320: pay_element_entry_values_f peev,
321: pay_input_values_f piv
322: WHERE pet.element_type_id = pel.element_type_id
323: AND pel.element_link_id = pee.element_link_id
324: AND pet.element_type_id = pete.element_type_id

Line 345: -- for the table pay_element_entry_values_f

341: AND pete.eei_information1 <>'L';
342:
343:
344: -- Cursor to fetch screen value WITHOUT CHECK ON SESSION_DATE
345: -- for the table pay_element_entry_values_f
346: -- Values fetched are based on effective_end_date
347: -- This is to fetch the current valid entry values
348:
349: CURSOR scr_val_cur1( p_name IN VARCHAR2

Line 357: pay_element_entry_values_f peev,

353: FROM pay_element_links_f pel,
354: pay_element_entries_f pee,
355: pay_element_types_f pet,
356: pay_element_type_extra_info pete,
357: pay_element_entry_values_f peev,
358: pay_input_values_f piv
359: WHERE pet.element_type_id = pel.element_type_id
360: AND pel.element_link_id = pee.element_link_id
361: AND pet.element_type_id = pete.element_type_id

Line 390: pay_element_entry_values_f peev,

386: FROM pay_element_links_f pel,
387: pay_element_entries_f pee,
388: pay_element_types_f pet,
389: pay_element_type_extra_info pete,
390: pay_element_entry_values_f peev,
391: pay_input_values_f piv
392: WHERE pet.element_type_id = pel.element_type_id
393: AND pel.element_link_id = pee.element_link_id
394: AND pet.element_type_id = pete.element_type_id

Line 425: l_scr_val PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;

421: l_end_date DATE;
422: l_ele_start_date DATE;
423: l_ele_end_date DATE;
424: l_last_ee_id_tmp NUMBER := -9999;
425: l_scr_val PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
426: l_ee_scr_val PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
427: l_ee_vehicle_type PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
428: l_paye_taxable PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
429: l_current_year VARCHAR2(5);

Line 426: l_ee_scr_val PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;

422: l_ele_start_date DATE;
423: l_ele_end_date DATE;
424: l_last_ee_id_tmp NUMBER := -9999;
425: l_scr_val PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
426: l_ee_scr_val PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
427: l_ee_vehicle_type PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
428: l_paye_taxable PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
429: l_current_year VARCHAR2(5);
430: l_ee_claim_end_date DATE;

Line 427: l_ee_vehicle_type PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;

423: l_ele_end_date DATE;
424: l_last_ee_id_tmp NUMBER := -9999;
425: l_scr_val PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
426: l_ee_scr_val PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
427: l_ee_vehicle_type PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
428: l_paye_taxable PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
429: l_current_year VARCHAR2(5);
430: l_ee_claim_end_date DATE;
431: l_asg_eff_ed DATE;

Line 428: l_paye_taxable PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;

424: l_last_ee_id_tmp NUMBER := -9999;
425: l_scr_val PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
426: l_ee_scr_val PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
427: l_ee_vehicle_type PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
428: l_paye_taxable PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value%TYPE;
429: l_current_year VARCHAR2(5);
430: l_ee_claim_end_date DATE;
431: l_asg_eff_ed DATE;
432: l_chk_start_date DATE;

Line 1538: FROM pay_element_entry_values_f peev,

1534: IS
1535:
1536: SELECT max(decode (piv.name, 'Category', peev.screen_entry_value)) Category,
1537: max(decode (piv.name,'Pension', peev.screen_entry_value)) Pension
1538: FROM pay_element_entry_values_f peev,
1539: pay_input_values_f piv
1540: WHERE peev.element_entry_id = p_element_type_id
1541: AND p_effective_start_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1542: AND peev.input_value_id = piv.input_value_id

Line 1578: FROM pay_element_entry_values_f peev,

1574: SELECT max (decode (piv.name, 'Type', peev.screen_entry_value)),
1575: max (decode (piv.name,'Reference', peev.screen_entry_value)),
1576: max (decode (piv.name,'Order Amount', peev.screen_entry_value)),
1577: max (decode (piv.name,'DEO Overriding Frequency', peev.screen_entry_value))
1578: FROM pay_element_entry_values_f peev,
1579: pay_input_values_f piv
1580: WHERE peev.element_entry_id = p_element_entry_id
1581: AND p_effective_start_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1582: AND peev.input_value_id = piv.input_value_id

Line 1590: l_type pay_element_entry_values_f.screen_entry_value%TYPE;

1586: AND piv.legislation_code = 'GB'
1587: ORDER BY piv.name DESC;
1588:
1589: l_element_name pay_element_types_f.element_name%TYPE;
1590: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1591: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1592: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;
1593: l_override_ndr pay_element_entry_values_f.screen_entry_value%TYPE;
1594: l_aggr_flag VARCHAR2(1) := 'N';

Line 1591: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;

1587: ORDER BY piv.name DESC;
1588:
1589: l_element_name pay_element_types_f.element_name%TYPE;
1590: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1591: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1592: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;
1593: l_override_ndr pay_element_entry_values_f.screen_entry_value%TYPE;
1594: l_aggr_flag VARCHAR2(1) := 'N';
1595: l_category varchar2(2);

Line 1592: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;

1588:
1589: l_element_name pay_element_types_f.element_name%TYPE;
1590: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1591: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1592: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;
1593: l_override_ndr pay_element_entry_values_f.screen_entry_value%TYPE;
1594: l_aggr_flag VARCHAR2(1) := 'N';
1595: l_category varchar2(2);
1596: l_pension varchar2(2);

Line 1593: l_override_ndr pay_element_entry_values_f.screen_entry_value%TYPE;

1589: l_element_name pay_element_types_f.element_name%TYPE;
1590: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1591: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1592: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;
1593: l_override_ndr pay_element_entry_values_f.screen_entry_value%TYPE;
1594: l_aggr_flag VARCHAR2(1) := 'N';
1595: l_category varchar2(2);
1596: l_pension varchar2(2);
1597:

Line 1716: FROM pay_element_entry_values_f peev,

1712: IS
1713:
1714: SELECT max(decode (piv.name, 'Category', peev.screen_entry_value)) Category,
1715: max(decode (piv.name,'Pension', peev.screen_entry_value)) Pension
1716: FROM pay_element_entry_values_f peev,
1717: pay_input_values_f piv
1718: WHERE peev.element_entry_id = p_element_entry_id
1719: AND p_effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1720: AND peev.input_value_id = piv.input_value_id

Line 1741: FROM pay_element_entry_values_f peev,

1737: SELECT max (decode (piv.name, 'Type', peev.screen_entry_value)),
1738: max (decode (piv.name,'Reference', peev.screen_entry_value)),
1739: max (decode (piv.name,'Order Amount', peev.screen_entry_value)),
1740: max (decode (piv.name,'DEO Overriding Frequency', peev.screen_entry_value))
1741: FROM pay_element_entry_values_f peev,
1742: pay_input_values_f piv
1743: WHERE peev.element_entry_id = p_element_entry_id
1744: AND p_effective_start_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1745: AND peev.input_value_id = piv.input_value_id

Line 1886: FROM pay_element_entry_values_f peev,

1882: --Added the below cursor for the bug fix# 10254292
1883: CURSOR csr_get_tax_code
1884: IS
1885: SELECT max (decode (piv.name, 'Tax Code', peev.screen_entry_value))
1886: FROM pay_element_entry_values_f peev,
1887: pay_input_values_f piv
1888: WHERE peev.element_entry_id = p_element_entry_id
1889: AND p_effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1890: AND peev.input_value_id = piv.input_value_id

Line 1915: l_type pay_element_entry_values_f.screen_entry_value%TYPE;

1911:
1912:
1913:
1914: l_element_name pay_element_types_f.element_name%TYPE;
1915: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1916: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1917: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;
1918:
1919: l_override_ndr pay_element_entry_values_f.screen_entry_value%TYPE;

Line 1916: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;

1912:
1913:
1914: l_element_name pay_element_types_f.element_name%TYPE;
1915: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1916: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1917: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;
1918:
1919: l_override_ndr pay_element_entry_values_f.screen_entry_value%TYPE;
1920: v_exists VARCHAR2(100) := 'N';

Line 1917: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;

1913:
1914: l_element_name pay_element_types_f.element_name%TYPE;
1915: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1916: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1917: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;
1918:
1919: l_override_ndr pay_element_entry_values_f.screen_entry_value%TYPE;
1920: v_exists VARCHAR2(100) := 'N';
1921: v_value varchar2(100) := 'Unknown';

Line 1919: l_override_ndr pay_element_entry_values_f.screen_entry_value%TYPE;

1915: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1916: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1917: l_amount pay_element_entry_values_f.screen_entry_value%TYPE;
1918:
1919: l_override_ndr pay_element_entry_values_f.screen_entry_value%TYPE;
1920: v_exists VARCHAR2(100) := 'N';
1921: v_value varchar2(100) := 'Unknown';
1922:
1923: --10157179 Begin