APPS.PSP_PAYTRN dependencies on FND_LOOKUP_VALUES_VL

Line 485: fnd_lookup_values_vl fvl,

481: psp_payroll_lines ppl
482: where ppc.run_id = l_run_id
483: and ppc.payroll_control_id = ppl.payroll_control_id
484: group by ppl.payroll_action_type, ppc.time_period_id, ppc.parent_payroll_control_id) kount,
485: fnd_lookup_values_vl fvl,
486: per_time_periods ptp
487: where kount.payroll_action_type = fvl.lookup_code
488: and fvl.lookup_type = 'ACTION_TYPE'
489: and sysdate between nvl(fvl.start_date_active,fnd_date.canonical_to_date('2000/01/31')) and nvl(fvl.end_date_active, fnd_date.canonical_to_date('4000/01/31'))

Line 501: from fnd_lookup_values_vl

497: and message_name = 'PSP_IMP_INDICATE_MASTER'
498: and language_code = userenv('LANG');
499: cursor get_import_summary_heading is
500: select meaning
501: from fnd_lookup_values_vl
502: where lookup_code in ('LABEL1_IMP_SUM', 'LABEL2_IMP_SUM', 'LABEL3_IMP_SUM', 'LABEL4_IMP_SUM')
503: and lookup_type = 'PSP_MESSAGE_TEXT'
504: and sysdate between start_date_active and nvl(end_date_active, fnd_date.canonical_to_date('4000/01/31'))
505: order by lookup_code;