APPS.PAY_PAYWSMEE_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1175: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE

1171: -- to avoid truncation of lookup meanings to 60 chars
1172: --
1173: TYPE fetched_entry_value_rec IS RECORD
1174: (
1175: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE
1176: ,screen_entry_value VARCHAR2(240) -- to avoid truncation of lookup meaning
1177: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1178: ,name pay_input_values_f_tl.name%TYPE
1179: ,uom pay_input_values_f.uom%TYPE

Line 1177: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE

1173: TYPE fetched_entry_value_rec IS RECORD
1174: (
1175: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE
1176: ,screen_entry_value VARCHAR2(240) -- to avoid truncation of lookup meaning
1177: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1178: ,name pay_input_values_f_tl.name%TYPE
1179: ,uom pay_input_values_f.uom%TYPE
1180: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1181: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE

Line 1234: from pay_element_entry_values_f ENTRY,

1230: decode (type.hot_default_flag,
1231: 'N', link.default_value,
1232: nvl (link.default_value,
1233: type.default_value)) DEFAULT_VALUE
1234: from pay_element_entry_values_f ENTRY,
1235: pay_link_input_values_f LINK,
1236: pay_input_values_f_tl TYPE_TL,
1237: pay_input_values_f TYPE
1238: where entry.element_entry_id = p_element_entry_id

Line 1315: -- PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value is stored as varchar2(60),

1311: -- If the entry value is not a lookup, then format it for display
1312: --
1313: --
1314: -- sbilling
1315: -- PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value is stored as varchar2(60),
1316: -- hr_chkfmt.changeformat() could return a 80 byte string which
1317: -- will not fit on PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value,
1318: -- therefore use substrb() to truncate this to 60 characters before
1319: -- storing on dB,

Line 1317: -- will not fit on PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value,

1313: --
1314: -- sbilling
1315: -- PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value is stored as varchar2(60),
1316: -- hr_chkfmt.changeformat() could return a 80 byte string which
1317: -- will not fit on PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value,
1318: -- therefore use substrb() to truncate this to 60 characters before
1319: -- storing on dB,
1320: -- nb. substrb() must be used as the dB could be set up as multibyte,
1321: -- in which case each byte must be returned as 2 bytes