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 5721: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');

5717: OPEN csr_get_table_id('PAY_ELEMENT_ENTRIES_F');
5718: FETCH csr_get_table_id INTO l_table1;
5719: CLOSE csr_get_table_id;
5720: --
5721: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');
5722: FETCH csr_get_table_id INTO l_table2;
5723: CLOSE csr_get_table_id;
5724: --
5725: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');

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

5726: FETCH csr_get_table_id INTO l_table3;
5727: CLOSE csr_get_table_id;
5728: --
5729: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRIES_F : '||l_table1);
5730: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PAY_ELEMENT_ENTRY_VALUES_F : '||l_table1);
5731: --##--Fnd_file.put_line(FND_FILE.LOG,'#######dated_table_id PER_ASSIGNMENT_EXTRA_INFO : '||l_table1);
5732: l_cnt := 1;
5733: FOR c_rec IN csr_get_element_entries(p_assignment_id,p_end_date) LOOP
5734: --##--Fnd_file.put_line(FND_FILE.LOG,'####### Calling interpretor for element_entry_id : '||c_rec.element_entry_id);

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

6178: --
6179: CURSOR csr_get_table_id(c_table_name VARCHAR2) IS
6180: SELECT dated_table_id
6181: FROM pay_dated_tables
6182: WHERE TABLE_NAME = c_table_name; -- in ('PAY_ELEMENT_ENTRY_VALUES_F','PAY_ELEMENT_ENTRIES_F');
6183: --
6184: CURSOR csr_get_element_det(c_element_name VARCHAR2
6185: ,c_input_val_name VARCHAR2
6186: ,c_assignment_id NUMBER

Line 6192: ,pay_element_entry_values_f peev

6188: SELECT peev.screen_entry_value
6189: FROM pay_element_types_f pet
6190: ,pay_input_values_f piv
6191: ,pay_element_entries_f peef
6192: ,pay_element_entry_values_f peev
6193: WHERE pet.element_name = c_element_name
6194: AND pet.element_type_id = piv.element_type_id
6195: AND piv.name = c_input_val_name
6196: AND pet.legislation_code = 'NL'

Line 6217: ,pay_element_entry_values_f peev

6213: SELECT pet.element_name
6214: ,peev.screen_entry_value
6215: FROM pay_element_types_f pet
6216: ,pay_element_entries_f peef
6217: ,pay_element_entry_values_f peev
6218: WHERE peev.element_entry_value_id = c_element_entry_value_id
6219: AND peev.element_entry_id = peef.element_entry_id
6220: AND peef.element_type_id = pet.element_type_id
6221: AND pet.legislation_code = 'NL'

Line 6235: ,pay_element_entry_values_f peev

6231: SELECT pet.element_name
6232: ,peev.screen_entry_value
6233: FROM pay_element_types_f pet
6234: ,pay_element_entries_f peef
6235: ,pay_element_entry_values_f peev
6236: WHERE peef.element_entry_id = c_element_entry_id
6237: AND peev.element_entry_id = peef.element_entry_id
6238: AND peef.element_type_id = pet.element_type_id
6239: AND pet.legislation_code = 'NL'

Line 6342: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;

6338: l_table3 pay_dated_tables.dated_table_id%type;
6339: l_ass_start_date DATE;
6340: l_ass_end_date DATE;
6341: --
6342: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
6343: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
6344: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
6345: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
6346: l_val pay_element_entry_values_f.screen_entry_value%TYPE;

Line 6343: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;

6339: l_ass_start_date DATE;
6340: l_ass_end_date DATE;
6341: --
6342: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
6343: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
6344: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
6345: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
6346: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
6347: l_element_name VARCHAR2(30);

Line 6344: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;

6340: l_ass_end_date DATE;
6341: --
6342: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
6343: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
6344: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
6345: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
6346: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
6347: l_element_name VARCHAR2(30);
6348: --

Line 6345: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;

6341: --
6342: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
6343: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
6344: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
6345: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
6346: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
6347: l_element_name VARCHAR2(30);
6348: --
6349: l_cnt1 NUMBER;

Line 6346: l_val pay_element_entry_values_f.screen_entry_value%TYPE;

6342: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
6343: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
6344: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
6345: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
6346: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
6347: l_element_name VARCHAR2(30);
6348: --
6349: l_cnt1 NUMBER;
6350: l_cnt2 NUMBER;

Line 6422: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');

6418: OPEN csr_get_table_id('PAY_ELEMENT_ENTRIES_F');
6419: FETCH csr_get_table_id INTO l_table1;
6420: CLOSE csr_get_table_id;
6421: --
6422: OPEN csr_get_table_id('PAY_ELEMENT_ENTRY_VALUES_F');
6423: FETCH csr_get_table_id INTO l_table2;
6424: CLOSE csr_get_table_id;
6425: --
6426: OPEN csr_get_table_id('PER_ASSIGNMENT_EXTRA_INFO');

Line 8479: ,pay_element_entry_values_f peev

8475: SELECT peev.screen_entry_value
8476: FROM pay_element_types_f pet
8477: ,pay_input_values_f piv
8478: ,pay_element_entries_f peef
8479: ,pay_element_entry_values_f peev
8480: WHERE pet.element_name = c_element_name
8481: AND pet.element_type_id = piv.element_type_id
8482: AND piv.name = c_input_val_name
8483: AND pet.legislation_code = 'NL'

Line 8504: ,pay_element_entry_values_f peev

8500: SELECT pet.element_name
8501: ,peev.screen_entry_value
8502: FROM pay_element_types_f pet
8503: ,pay_element_entries_f peef
8504: ,pay_element_entry_values_f peev
8505: WHERE peev.element_entry_value_id = c_element_entry_value_id
8506: AND peev.element_entry_id = peef.element_entry_id
8507: AND peef.element_type_id = pet.element_type_id
8508: AND pet.legislation_code = 'NL'

Line 8522: ,pay_element_entry_values_f peev

8518: SELECT pet.element_name
8519: ,peev.screen_entry_value
8520: FROM pay_element_types_f pet
8521: ,pay_element_entries_f peef
8522: ,pay_element_entry_values_f peev
8523: WHERE peef.element_entry_id = c_element_entry_id
8524: AND peev.element_entry_id = peef.element_entry_id
8525: AND peef.element_type_id = pet.element_type_id
8526: AND pet.legislation_code = 'NL'

Line 8619: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;

8615: l_table3 pay_dated_tables.dated_table_id%type;
8616: l_ass_start_date DATE;
8617: l_ass_end_date DATE;
8618: --
8619: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
8620: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
8621: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
8622: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
8623: l_val pay_element_entry_values_f.screen_entry_value%TYPE;

Line 8620: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;

8616: l_ass_start_date DATE;
8617: l_ass_end_date DATE;
8618: --
8619: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
8620: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
8621: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
8622: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
8623: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
8624: l_element_name VARCHAR2(30);

Line 8621: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;

8617: l_ass_end_date DATE;
8618: --
8619: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
8620: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
8621: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
8622: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
8623: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
8624: l_element_name VARCHAR2(30);
8625: --

Line 8622: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;

8618: --
8619: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
8620: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
8621: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
8622: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
8623: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
8624: l_element_name VARCHAR2(30);
8625: --
8626: l_cnt1 NUMBER;

Line 8623: l_val pay_element_entry_values_f.screen_entry_value%TYPE;

8619: l_holiday_coupen pay_element_entry_values_f.screen_entry_value%TYPE;
8620: l_income_increase pay_element_entry_values_f.screen_entry_value%TYPE;
8621: l_add_allowance pay_element_entry_values_f.screen_entry_value%TYPE;
8622: l_company_car_use pay_element_entry_values_f.screen_entry_value%TYPE;
8623: l_val pay_element_entry_values_f.screen_entry_value%TYPE;
8624: l_element_name VARCHAR2(30);
8625: --
8626: l_cnt1 NUMBER;
8627: l_cnt2 NUMBER;