APPS.PAY_PAYWSMEE_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1151: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE

1147: -- to avoid truncation of lookup meanings to 60 chars
1148: --
1149: TYPE fetched_entry_value_rec IS RECORD
1150: (
1151: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE
1152: ,screen_entry_value VARCHAR2(80) -- to avoid truncation of lookup meaning
1153: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1154: ,name pay_input_values_f_tl.name%TYPE
1155: ,uom pay_input_values_f.uom%TYPE

Line 1153: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE

1149: TYPE fetched_entry_value_rec IS RECORD
1150: (
1151: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE
1152: ,screen_entry_value VARCHAR2(80) -- to avoid truncation of lookup meaning
1153: ,input_value_id pay_element_entry_values_f.input_value_id%TYPE
1154: ,name pay_input_values_f_tl.name%TYPE
1155: ,uom pay_input_values_f.uom%TYPE
1156: ,hot_default_flag pay_input_values_f.hot_default_flag%TYPE
1157: ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE

Line 1210: from pay_element_entry_values_f ENTRY,

1206: decode (type.hot_default_flag,
1207: 'N', link.default_value,
1208: nvl (link.default_value,
1209: type.default_value)) DEFAULT_VALUE
1210: from pay_element_entry_values_f ENTRY,
1211: pay_link_input_values_f LINK,
1212: pay_input_values_f_tl TYPE_TL,
1213: pay_input_values_f TYPE
1214: where entry.element_entry_id = p_element_entry_id

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

1287: -- If the entry value is not a lookup, then format it for display
1288: --
1289: --
1290: -- sbilling
1291: -- PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value is stored as varchar2(60),
1292: -- hr_chkfmt.changeformat() could return a 80 byte string which
1293: -- will not fit on PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value,
1294: -- therefore use substrb() to truncate this to 60 characters before
1295: -- storing on dB,

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

1289: --
1290: -- sbilling
1291: -- PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value is stored as varchar2(60),
1292: -- hr_chkfmt.changeformat() could return a 80 byte string which
1293: -- will not fit on PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value,
1294: -- therefore use substrb() to truncate this to 60 characters before
1295: -- storing on dB,
1296: -- nb. substrb() must be used as the dB could be set up as multibyte,
1297: -- in which case each byte must be returned as 2 bytes