DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on FND_LOOKUP_VALUES

Line 389: from fnd_lookup_values

385: cursor c_chk_footnote is
386: select 'Y'
387: from dual
388: where exists (select 'X'
389: from fnd_lookup_values
390: where ((lookup_type = 'PAY_CA_RL2_FOOTNOTES'
391: and lookup_code = p_footnote_code)
392: OR (lookup_type = 'PAY_CA_RL2_AUTOMATIC_FOOTNOTES'
393: and lookup_code = p_footnote_code))

Line 2663: fnd_lookup_values flv

2659: pay_balance_types pbt,
2660: pay_balance_types pbt1,
2661: pay_input_values_f piv,
2662: pay_element_types_f pet,
2663: fnd_lookup_values flv
2664: where pbt.balance_name = p_balance_name
2665: and pbf.balance_type_id = pbt.balance_type_id
2666: and pbf.input_value_id = piv.input_value_id
2667: and piv.element_type_id = pet.element_type_id