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 1543: FROM pay_element_entry_values_f peev,

1539: CURSOR csr_get_ele_ent_values
1540: IS
1541: SELECT max (decode (piv.name, 'Type', peev.screen_entry_value)),
1542: max (decode (piv.name,'Reference', peev.screen_entry_value))
1543: FROM pay_element_entry_values_f peev,
1544: pay_input_values_f piv
1545: WHERE peev.element_entry_id = p_element_entry_id
1546: AND p_effective_start_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1547: AND peev.input_value_id = piv.input_value_id

Line 1555: l_type pay_element_entry_values_f.screen_entry_value%TYPE;

1551: AND piv.legislation_code = 'GB'
1552: ORDER BY piv.name DESC;
1553:
1554: l_element_name pay_element_types_f.element_name%TYPE;
1555: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1556: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1557:
1558: BEGIN
1559:

Line 1556: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;

1552: ORDER BY piv.name DESC;
1553:
1554: l_element_name pay_element_types_f.element_name%TYPE;
1555: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1556: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1557:
1558: BEGIN
1559:
1560: hr_utility.set_location('Entering procedure pqp_gb_ad_ee.AI_VAL_REF_COURT_ORDER',10);

Line 1632: FROM pay_element_entry_values_f peev,

1628: CURSOR csr_get_ele_ent_values
1629: IS
1630: SELECT max (decode (piv.name, 'Type', peev.screen_entry_value)),
1631: max (decode (piv.name,'Reference', peev.screen_entry_value))
1632: FROM pay_element_entry_values_f peev,
1633: pay_input_values_f piv
1634: WHERE peev.element_entry_id = p_element_entry_id
1635: AND p_effective_date BETWEEN peev.effective_start_date AND peev.effective_end_date
1636: AND peev.input_value_id = piv.input_value_id

Line 1697: l_type pay_element_entry_values_f.screen_entry_value%TYPE;

1693: WHERE prr2.source_id = PRR.run_result_id
1694: AND prr2.source_type IN ('R', 'V'));
1695:
1696: l_element_name pay_element_types_f.element_name%TYPE;
1697: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1698: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1699:
1700: v_exists VARCHAR2(100) := 'N';
1701: v_value varchar2(100) := 'Unknown';

Line 1698: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;

1694: AND prr2.source_type IN ('R', 'V'));
1695:
1696: l_element_name pay_element_types_f.element_name%TYPE;
1697: l_type pay_element_entry_values_f.screen_entry_value%TYPE;
1698: l_reference pay_element_entry_values_f.screen_entry_value%TYPE;
1699:
1700: v_exists VARCHAR2(100) := 'N';
1701: v_value varchar2(100) := 'Unknown';
1702: