APPS.PAY_PAYWSQEE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 924: from pay_element_types_f ELT,

920: p_element_name in out nocopy varchar2) is
921: --
922: cursor csr_element is
923: select distinct elt.element_type_id, elt.element_name
924: from pay_element_types_f ELT,
925: pay_batch_lines LINE
926: where line.batch_id = p_batch_id and
927: line.element_type_id is not null and
928: line.element_type_id = elt.element_type_id

Line 931: from pay_element_types_f ELT,

927: line.element_type_id is not null and
928: line.element_type_id = elt.element_type_id
929: union
930: select distinct elt.element_type_id, elt.element_name
931: from pay_element_types_f ELT,
932: pay_batch_lines LINE
933: where line.batch_id = p_batch_id and
934: line.element_type_id is null and
935: upper (line.element_name) = upper(elt.element_name);

Line 1238: l_currency_code pay_element_types_f.input_currency_code%TYPE;

1234: --
1235: l_uom_value pay_input_values_f.UOM%TYPE;
1236: l_lookup_type pay_input_values_f.LOOKUP_TYPE%TYPE;
1237: l_value_set_id pay_input_values_f.VALUE_SET_ID%TYPE;
1238: l_currency_code pay_element_types_f.input_currency_code%TYPE;
1239: l_count number;
1240: l_found number;
1241: --
1242: cursor csr_valid_lookup

Line 1256: pay_element_types_f etp

1252: inv.LOOKUP_TYPE,
1253: inv.VALUE_SET_ID,
1254: etp.input_currency_code
1255: from pay_input_values_f inv,
1256: pay_element_types_f etp
1257: where inv.element_type_id = p_element_type_id
1258: and etp.element_type_id = p_element_type_id
1259: and p_session_date between inv.effective_start_date
1260: and inv.effective_end_date