APPS.PAY_EEI_MIG_BUS dependencies on PAY_RATES

Line 541: l_business_group_id pay_rates.business_group_id%type ;

537: ) is
538: --
539: l_proc varchar2(72) := g_package||'chk_qualifier';
540: l_exists varchar2(10);
541: l_business_group_id pay_rates.business_group_id%type ;
542:
543: cursor c_input_value is
544: select 'Y'
545: from pay_input_values_f paf

Line 567: from pay_rates pr

563:
564:
565: cursor c_grade_rate is
566: select 'Y'
567: from pay_rates pr
568: where upper(name) = upper(p_qualifier)
569: and rate_type = 'G'
570: and pr.business_group_id = nvl(l_business_group_id,pr.business_group_id) ;
571:

Line 574: from pay_rates pr

570: and pr.business_group_id = nvl(l_business_group_id,pr.business_group_id) ;
571:
572: cursor c_grade_rate_like is
573: select 'Y'
574: from pay_rates pr
575: where upper(name) like upper(p_qualifier)
576: and rate_type = 'G'
577: and pr.business_group_id = nvl(l_business_group_id,pr.business_group_id);
578:

Line 582: from pay_rates pr

578:
579:
580: cursor c_spinal_point is
581: select 'Y'
582: from pay_rates pr
583: where upper(name) = upper(p_qualifier)
584: and rate_type = 'SP'
585: and pr.business_group_id = nvl(l_business_group_id,pr.business_group_id) ;
586:

Line 589: from pay_rates pr

585: and pr.business_group_id = nvl(l_business_group_id,pr.business_group_id) ;
586:
587: cursor c_spinal_point_like is
588: select 'Y'
589: from pay_rates pr
590: where upper(name) like upper(p_qualifier)
591: and rate_type = 'SP'
592: and pr.business_group_id = nvl(l_business_group_id,pr.business_group_id);
593: