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.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 9387: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');

9383: OPEN csr_get_table_id('PAY_ELEMENT_ENTRIES_F');
9384: FETCH csr_get_table_id INTO l_table1;
9385: CLOSE csr_get_table_id;
9386: --
9387: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');
9388: FETCH csr_get_table_id INTO l_table2;
9389: CLOSE csr_get_table_id;
9390: --
9391: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');

Line 9396: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRY_VALUES_F : '||l_table1);

9392: FETCH csr_get_table_id INTO l_table3;
9393: CLOSE csr_get_table_id;
9394: --
9395: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRIES_F : '||l_table1);
9396: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRY_VALUES_F : '||l_table1);
9397: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PER_ASSIGNMENT_EXTRA_INFO : '||l_table1);
9398: l_cnt := 1;
9399: FOR c_rec IN csr_get_element_entries(p_assignment_id,p_end_date) LOOP
9400: --##--Fnd_file.put_line(FND_FILE.LOG,'####### Calling interpretor for element_entry_id : '||c_rec.element_entry_id);

Line 9851: WHERE TABLE_NAME = c_table_name; -- in ('PAY_ELEMENT_ENTRY_VALUES_F','PAY_ELEMENT_ENTRIES_F');

9847: --
9848: CURSOR csr_get_table_id(c_table_name VARCHAR2) IS
9849: SELECT dated_table_id
9850: FROM pay_dated_tables
9851: WHERE TABLE_NAME = c_table_name; -- in ('PAY_ELEMENT_ENTRY_VALUES_F','PAY_ELEMENT_ENTRIES_F');
9852: --
9853: CURSOR csr_get_element_det(c_element_name VARCHAR2
9854: ,c_input_val_name VARCHAR2
9855: ,c_assignment_id NUMBER

Line 9861: ,pay_element_entry_values_f peev

9857: SELECT peev.screen_entry_value
9858: FROM pay_element_types_f pet
9859: ,pay_input_values_f piv
9860: ,pay_element_entries_f peef
9861: ,pay_element_entry_values_f peev
9862: WHERE pet.element_name = c_element_name
9863: AND pet.element_type_id = piv.element_type_id
9864: AND piv.name = c_input_val_name
9865: AND pet.legislation_code = 'NL'

Line 9886: ,pay_element_entry_values_f peev

9882: SELECT pet.element_name
9883: ,peev.screen_entry_value
9884: FROM pay_element_types_f pet
9885: ,pay_element_entries_f peef
9886: ,pay_element_entry_values_f peev
9887: WHERE peev.element_entry_value_id = c_element_entry_value_id
9888: AND peev.element_entry_id = peef.element_entry_id
9889: AND peef.element_type_id = pet.element_type_id
9890: AND pet.legislation_code = 'NL'

Line 9904: ,pay_element_entry_values_f peev

9900: SELECT pet.element_name
9901: ,peev.screen_entry_value
9902: FROM pay_element_types_f pet
9903: ,pay_element_entries_f peef
9904: ,pay_element_entry_values_f peev
9905: WHERE peef.element_entry_id = c_element_entry_id
9906: AND peev.element_entry_id = peef.element_entry_id
9907: AND peef.element_type_id = pet.element_type_id
9908: AND pet.legislation_code = 'NL'

Line 10087: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;

10083: l_table3 pay_dated_tables.dated_table_id%type;
10084: l_ass_start_date DATE;
10085: l_ass_end_date DATE;
10086: --
10087: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
10088: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
10089: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
10090: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
10091: l_val pay_element_entry_values_f.screen_entry_value%TYPE;

Line 10088: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;

10084: l_ass_start_date DATE;
10085: l_ass_end_date DATE;
10086: --
10087: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
10088: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
10089: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
10090: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
10091: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
10092: l_element_name VARCHAR2(30);

Line 10089: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;

10085: l_ass_end_date DATE;
10086: --
10087: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
10088: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
10089: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
10090: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
10091: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
10092: l_element_name VARCHAR2(30);
10093: --

Line 10090: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;

10086: --
10087: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
10088: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
10089: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
10090: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
10091: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
10092: l_element_name VARCHAR2(30);
10093: --
10094: l_cnt1 NUMBER;

Line 10091: l_val pay_element_entry_values_f.screen_entry_value%TYPE;

10087: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
10088: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
10089: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
10090: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
10091: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
10092: l_element_name VARCHAR2(30);
10093: --
10094: l_cnt1 NUMBER;
10095: l_cnt2 NUMBER;

Line 10204: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');

10200: OPEN csr_get_table_id('PAY_ELEMENT_ENTRIES_F');
10201: FETCH csr_get_table_id INTO l_table1;
10202: CLOSE csr_get_table_id;
10203: --
10204: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');
10205: FETCH csr_get_table_id INTO l_table2;
10206: CLOSE csr_get_table_id;
10207: --
10208: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');

Line 14069: ,pay_element_entry_values_f peev

14065: SELECT peev.screen_entry_value
14066: FROM pay_element_types_f pet
14067: ,pay_input_values_f piv
14068: ,pay_element_entries_f peef
14069: ,pay_element_entry_values_f peev
14070: WHERE pet.element_name = c_element_name
14071: AND pet.element_type_id = piv.element_type_id
14072: AND piv.name = c_input_val_name
14073: AND pet.legislation_code = 'NL'

Line 14094: ,pay_element_entry_values_f peev

14090: SELECT pet.element_name
14091: ,peev.screen_entry_value
14092: FROM pay_element_types_f pet
14093: ,pay_element_entries_f peef
14094: ,pay_element_entry_values_f peev
14095: WHERE peev.element_entry_value_id = c_element_entry_value_id
14096: AND peev.element_entry_id = peef.element_entry_id
14097: AND peef.element_type_id = pet.element_type_id
14098: AND pet.legislation_code = 'NL'

Line 14112: ,pay_element_entry_values_f peev

14108: SELECT pet.element_name
14109: ,peev.screen_entry_value
14110: FROM pay_element_types_f pet
14111: ,pay_element_entries_f peef
14112: ,pay_element_entry_values_f peev
14113: WHERE peef.element_entry_id = c_element_entry_id
14114: AND peev.element_entry_id = peef.element_entry_id
14115: AND peef.element_type_id = pet.element_type_id
14116: AND pet.legislation_code = 'NL'

Line 14274: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;

14270: l_table3 pay_dated_tables.dated_table_id%type;
14271: l_ass_start_date DATE;
14272: l_ass_end_date DATE;
14273: --
14274: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
14275: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
14276: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
14277: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
14278: l_val pay_element_entry_values_f.screen_entry_value%TYPE;

Line 14275: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;

14271: l_ass_start_date DATE;
14272: l_ass_end_date DATE;
14273: --
14274: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
14275: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
14276: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
14277: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
14278: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
14279: l_element_name VARCHAR2(30);

Line 14276: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;

14272: l_ass_end_date DATE;
14273: --
14274: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
14275: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
14276: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
14277: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
14278: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
14279: l_element_name VARCHAR2(30);
14280: --

Line 14277: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;

14273: --
14274: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
14275: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
14276: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
14277: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
14278: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
14279: l_element_name VARCHAR2(30);
14280: --
14281: l_cnt1 NUMBER;

Line 14278: l_val pay_element_entry_values_f.screen_entry_value%TYPE;

14274: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
14275: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
14276: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
14277: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
14278: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
14279: l_element_name VARCHAR2(30);
14280: --
14281: l_cnt1 NUMBER;
14282: l_cnt2 NUMBER;