DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_PKG dependencies on HR_LOOKUPS

Line 1170: l_check hr_lookups.meaning%type;

1166: SELECT PT.number_per_fiscal_year
1167: FROM per_time_period_types PT
1168: WHERE UPPER(PT.period_type) = UPPER(p_frequency);
1169:
1170: l_check hr_lookups.meaning%type;
1171: l_proc varchar2(72) := g_package||'get_number_per_fiscal_year';
1172: Begin
1173: hr_utility.set_location('Entering:'||l_proc,5);
1174: Open csr_period_type;

Line 3383: FROM hr_lookups lkp

3379: --
3380: --
3381: SELECT lookup_code
3382: INTO v_pay_basis
3383: FROM hr_lookups lkp
3384: WHERE lkp.application_id = 800
3385: AND lkp.lookup_type = 'PAY_BASIS'
3386: AND lkp.lookup_code = p_freq;
3387: --