APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on HR_LOOKUPS

Line 3126: from hr_lookups hrl

3122: and pac.assignment_id = run_paa.assignment_id
3123: and pac.context_value = 'QC')
3124: order by 1; --Bug 6853279
3125: /* and exists (select 1 --Bug 7555410
3126: from hr_lookups hrl
3127: where hrl.lookup_code=prrv1.result_value
3128: and lookup_type='PAY_CA_RL1_NONBOX_FOOTNOTES'
3129: and cp_eff_date
3130: between nvl(hrl.start_date_active,to_date('1900/01/01','YYYY/MM/DD'))

Line 3137: from hr_lookups hrl

3133:
3134: /*For performance of non box footnote amounts - bug 8227027 */
3135: cursor c_non_box_lookup is
3136: select 1
3137: from hr_lookups hrl
3138: where hrl.lookup_code=l_messages
3139: and lookup_type='PAY_CA_RL1_NONBOX_FOOTNOTES'
3140: and p_effective_date
3141: between nvl(hrl.start_date_active,to_date('1900/01/01','YYYY/MM/DD'))