DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on FND_LOOKUP_VALUES

Line 350: from fnd_lookup_values

346: cursor c_chk_footnote is
347: select 'Y'
348: from dual
349: where exists (select 'X'
350: from fnd_lookup_values
351: where ((lookup_type = 'PAY_CA_RL2_FOOTNOTES'
352: and lookup_code = p_footnote_code)
353: OR (lookup_type = 'PAY_CA_RL2_AUTOMATIC_FOOTNOTES'
354: and lookup_code = p_footnote_code))

Line 1957: fnd_lookup_values flv

1953: pay_balance_types pbt,
1954: pay_balance_types pbt1,
1955: pay_input_values_f piv,
1956: pay_element_types_f pet,
1957: fnd_lookup_values flv
1958: where pbt.balance_name = p_balance_name
1959: and pbf.balance_type_id = pbt.balance_type_id
1960: and pbf.input_value_id = piv.input_value_id
1961: and piv.element_type_id = pet.element_type_id