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_KR_SEP_FORM_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 20: type element_name_tbl is table of pay_element_types_f.element_name%type index by binary_integer;

16: g_element_entry_id number;
17: g_input_value_index number;
18: type screen_entry_value_tbl is table of pay_element_entry_values_f.screen_entry_value%type index by binary_integer;
19: g_screen_entry_value_tbl screen_entry_value_tbl;
20: type element_name_tbl is table of pay_element_types_f.element_name%type index by binary_integer;
21: type element_type_id_tbl is table of pay_element_types_f.element_type_id%type index by binary_integer;
22: type input_value_id_tbl is table of pay_input_values_f.input_value_id%type index by binary_integer;
23: type display_sequence_tbl is table of pay_input_values_f.display_sequence%type index by binary_integer;
24: type lookup_type_tbl is table of pay_input_values_f.lookup_type%type index by binary_integer;

Line 21: type element_type_id_tbl is table of pay_element_types_f.element_type_id%type index by binary_integer;

17: g_input_value_index number;
18: type screen_entry_value_tbl is table of pay_element_entry_values_f.screen_entry_value%type index by binary_integer;
19: g_screen_entry_value_tbl screen_entry_value_tbl;
20: type element_name_tbl is table of pay_element_types_f.element_name%type index by binary_integer;
21: type element_type_id_tbl is table of pay_element_types_f.element_type_id%type index by binary_integer;
22: type input_value_id_tbl is table of pay_input_values_f.input_value_id%type index by binary_integer;
23: type display_sequence_tbl is table of pay_input_values_f.display_sequence%type index by binary_integer;
24: type lookup_type_tbl is table of pay_input_values_f.lookup_type%type index by binary_integer;
25: type mandatory_flag_tbl is table of pay_input_values_f.mandatory_flag%type index by binary_integer;

Line 330: l_processing_type pay_element_types_f.processing_type%TYPE;

326: --
327: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
328: --
329: l_entry_type pay_element_entries_f.entry_type%TYPE;
330: l_processing_type pay_element_types_f.processing_type%TYPE;
331: --
332: cursor C_Sel1 is
333: select pee.entry_type,
334: pet.processing_type

Line 335: from pay_element_types_f pet,

331: --
332: cursor C_Sel1 is
333: select pee.entry_type,
334: pet.processing_type
335: from pay_element_types_f pet,
336: pay_element_links_f pel,
337: pay_element_entries_f pee
338: where pee.element_entry_id = p_base_key_value
339: and p_effective_date

Line 406: l_processing_type pay_element_types_f.processing_type%TYPE;

402: --
403: l_parent_key_value1 number;
404: l_parent_key_value2 number;
405: l_entry_type pay_element_entries_f.entry_type%TYPE;
406: l_processing_type pay_element_types_f.processing_type%TYPE;
407: --
408: cursor C_Sel1 is
409: select pee.assignment_id,
410: pee.element_link_id,

Line 413: from pay_element_types_f pet,

409: select pee.assignment_id,
410: pee.element_link_id,
411: pee.entry_type,
412: pet.processing_type
413: from pay_element_types_f pet,
414: pay_element_links_f pel,
415: pay_element_entries_f pee
416: where pee.element_entry_id = p_base_key_value
417: and p_effective_date

Line 1017: from pay_element_types_f pet,

1013: decode(piv.hot_default_flag,
1014: 'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
1015: pliv.warning_or_error) WARNING_OR_ERROR,
1016: pet.input_currency_code
1017: from pay_element_types_f pet,
1018: pay_input_values_f_tl pivtl,
1019: pay_input_values_f piv,
1020: pay_link_input_values_f pliv
1021: where pliv.element_link_id = p_element_link_id

Line 1255: from pay_element_types_f pet

1251: --
1252: cursor csr_element_type_id
1253: is
1254: select pet.element_type_id
1255: from pay_element_types_f pet
1256: where pet.element_name = p_element_name
1257: and l_effective_date
1258: between pet.effective_start_date and pet.effective_end_date
1259: and nvl(pet.legislation_code,g_legislation_code) = g_legislation_code

Line 1857: from pay_element_types_f pet,

1853: null,
1854: decode(piv.hot_default_flag,
1855: 'Y',nvl(pliv.default_value,piv.default_value),
1856: pliv.default_value)) b_default_value
1857: from pay_element_types_f pet,
1858: pay_input_values_f piv,
1859: pay_link_input_values_f pliv
1860: where pliv.element_link_id = p_element_link_id
1861: and p_effective_date

Line 2057: from pay_element_types_f pet,

2053: hr_general.decode_lookup(piv.lookup_type,
2054: nvl(l_screen_value,decode(piv.hot_default_flag,
2055: 'Y',nvl(pliv.default_value,piv.default_value),
2056: pliv.default_value)))),piv.uom,pet.output_currency_code),1,60) entry_value
2057: from pay_element_types_f pet,
2058: pay_input_values_f piv,
2059: pay_link_input_values_f pliv
2060: where pliv.element_link_id = p_el_element_link_id
2061: and pliv.input_value_id = l_input_value_id

Line 2136: pay_element_types_f pet,

2132: and nvl(hr_entry_api.get_link(p_assignment_id,petr.element_type_id,p_session_date),0) <> 0
2133: and petr.element_type_id not in(
2134: select distinct pet.element_type_id
2135: from pay_element_entries_f pee,
2136: pay_element_types_f pet,
2137: pay_element_links_f pel
2138: where assignment_id = p_assignment_id
2139: and pet.element_type_id = pel.element_type_id
2140: and pee.element_link_id = pel.element_link_id

Line 2220: pay_element_types_f pet,

2216: and nvl(hr_entry_api.get_link(p_assignment_id,petr.element_type_id,p_session_date),0) <> 0
2217: and petr.element_type_id not in(
2218: select distinct pet.element_type_id
2219: from pay_element_entries_f pee,
2220: pay_element_types_f pet,
2221: pay_element_links_f pel
2222: where assignment_id = p_assignment_id
2223: and pet.element_type_id = pel.element_type_id
2224: and pee.element_link_id = pel.element_link_id