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_INPUT_VALUES_F

Line 22: type input_value_id_tbl is table of pay_input_values_f.input_value_id%type index by binary_integer;

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;
26: type input_value_name_tbl is table of pay_input_values_f.name%type index by binary_integer;

Line 23: type display_sequence_tbl is table of pay_input_values_f.display_sequence%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;
26: type input_value_name_tbl is table of pay_input_values_f.name%type index by binary_integer;
27: type input_value_d_name_tbl is table of pay_input_values_f_tl.name%type index by binary_integer;

Line 24: type lookup_type_tbl is table of pay_input_values_f.lookup_type%type index by binary_integer;

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;
26: type input_value_name_tbl is table of pay_input_values_f.name%type index by binary_integer;
27: type input_value_d_name_tbl is table of pay_input_values_f_tl.name%type index by binary_integer;
28: type get_input_value_id_rec is record(

Line 25: type mandatory_flag_tbl is table of pay_input_values_f.mandatory_flag%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;
26: type input_value_name_tbl is table of pay_input_values_f.name%type index by binary_integer;
27: type input_value_d_name_tbl is table of pay_input_values_f_tl.name%type index by binary_integer;
28: type get_input_value_id_rec is record(
29: element_type_id element_type_id_tbl,

Line 26: type input_value_name_tbl is table of pay_input_values_f.name%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;
26: type input_value_name_tbl is table of pay_input_values_f.name%type index by binary_integer;
27: type input_value_d_name_tbl is table of pay_input_values_f_tl.name%type index by binary_integer;
28: type get_input_value_id_rec is record(
29: element_type_id element_type_id_tbl,
30: input_value_id input_value_id_tbl,

Line 27: type input_value_d_name_tbl is table of pay_input_values_f_tl.name%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;
26: type input_value_name_tbl is table of pay_input_values_f.name%type index by binary_integer;
27: type input_value_d_name_tbl is table of pay_input_values_f_tl.name%type index by binary_integer;
28: type get_input_value_id_rec is record(
29: element_type_id element_type_id_tbl,
30: input_value_id input_value_id_tbl,
31: display_sequence display_sequence_tbl,

Line 1018: pay_input_values_f_tl pivtl,

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
1022: and pliv.input_value_id = p_input_value_id

Line 1019: pay_input_values_f piv,

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
1022: and pliv.input_value_id = p_input_value_id
1023: and p_effective_date

Line 1341: from pay_input_values_f_tl pivtl,

1337: piv.lookup_type lookup_type,
1338: piv.mandatory_flag mandatory_flag,
1339: piv.name name,
1340: pivtl.name d_name
1341: from pay_input_values_f_tl pivtl,
1342: pay_input_values_f piv
1343: where piv.element_type_id = p_element_type_id
1344: and l_effective_date
1345: between piv.effective_start_date and piv.effective_end_date

Line 1342: pay_input_values_f piv

1338: piv.mandatory_flag mandatory_flag,
1339: piv.name name,
1340: pivtl.name d_name
1341: from pay_input_values_f_tl pivtl,
1342: pay_input_values_f piv
1343: where piv.element_type_id = p_element_type_id
1344: and l_effective_date
1345: between piv.effective_start_date and piv.effective_end_date
1346: and pivtl.input_value_id = piv.input_value_id

Line 1480: l_input_value_name pay_input_values_f_tl.name%type;

1476: is
1477: --
1478: l_effective_date date;
1479: l_input_value_id number;
1480: l_input_value_name pay_input_values_f_tl.name%type;
1481: l_index number;
1482: l_csr_index number := 0;
1483: --
1484: cursor csr_input_value_name

Line 1488: from pay_input_values_f_tl pivtl,

1484: cursor csr_input_value_name
1485: is
1486: select piv.name name,
1487: pivtl.name d_name
1488: from pay_input_values_f_tl pivtl,
1489: pay_input_values_f piv
1490: where piv.element_type_id = p_element_type_id
1491: and l_effective_date
1492: between piv.effective_start_date and piv.effective_end_date

Line 1489: pay_input_values_f piv

1485: is
1486: select piv.name name,
1487: pivtl.name d_name
1488: from pay_input_values_f_tl pivtl,
1489: pay_input_values_f piv
1490: where piv.element_type_id = p_element_type_id
1491: and l_effective_date
1492: between piv.effective_start_date and piv.effective_end_date
1493: and pivtl.input_value_id = piv.input_value_id

Line 1565: from pay_input_values_f piv

1561: --
1562: cursor csr_input_value_d_sequence
1563: is
1564: select piv.display_sequence display_sequence
1565: from pay_input_values_f piv
1566: where piv.element_type_id = p_element_type_id
1567: and l_effective_date
1568: between piv.effective_start_date and piv.effective_end_date
1569: order by piv.display_sequence, piv.name;

Line 1632: l_input_value_lookup_type pay_input_values_f.lookup_type%type;

1628: is
1629: --
1630: l_effective_date date;
1631: l_input_value_id number;
1632: l_input_value_lookup_type pay_input_values_f.lookup_type%type;
1633: l_index number;
1634: l_csr_index number := 0;
1635: --
1636: cursor csr_input_value_lookup_type

Line 1639: from pay_input_values_f piv

1635: --
1636: cursor csr_input_value_lookup_type
1637: is
1638: select piv.lookup_type lookup_type
1639: from pay_input_values_f piv
1640: where piv.element_type_id = p_element_type_id
1641: and l_effective_date
1642: between piv.effective_start_date and piv.effective_end_date
1643: order by piv.display_sequence, piv.name;

Line 1706: l_input_value_mandatory pay_input_values_f.mandatory_flag%type;

1702: is
1703: --
1704: l_effective_date date;
1705: l_input_value_id number;
1706: l_input_value_mandatory pay_input_values_f.mandatory_flag%type;
1707: l_index number;
1708: l_csr_index number := 0;
1709: --
1710: cursor csr_input_value_mandatory

Line 1713: from pay_input_values_f piv

1709: --
1710: cursor csr_input_value_mandatory
1711: is
1712: select piv.mandatory_flag mandatory_flag
1713: from pay_input_values_f piv
1714: where piv.element_type_id = p_element_type_id
1715: and l_effective_date
1716: between piv.effective_start_date and piv.effective_end_date
1717: order by piv.display_sequence, piv.name;

Line 1858: pay_input_values_f piv,

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
1862: between pliv.effective_start_date and pliv.effective_end_date

Line 2058: pay_input_values_f piv,

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
2062: and g_session_date /* set by get_input_value_id */