APPS.PSP_PAYTRN dependencies on FND_LOOKUP_VALUES_VL

Line 487: fnd_lookup_values_vl fvl,

483: psp_payroll_lines ppl
484: where ppc.run_id = l_run_id
485: and ppc.payroll_control_id = ppl.payroll_control_id
486: group by ppl.payroll_action_type, ppc.time_period_id, ppc.parent_payroll_control_id) kount,
487: fnd_lookup_values_vl fvl,
488: per_time_periods ptp
489: where kount.payroll_action_type = fvl.lookup_code
490: and fvl.lookup_type = 'ACTION_TYPE'
491: 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 503: from fnd_lookup_values_vl

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