APPS.PQP_EXR_SWI dependencies on PER_BUSINESS_GROUPS

Line 651: l_legislation_code_l per_business_groups.legislation_code%TYPE;

647: -- ----------------------------------------------------------------------------
648: FUNCTION get_legislation_code (p_business_group_id IN NUMBER)
649: RETURN VARCHAR2
650: IS
651: l_legislation_code_l per_business_groups.legislation_code%TYPE;
652: BEGIN
653: hr_utility.trace('Enter Legislation code');
654: SELECT legislation_code
655: INTO l_legislation_code_l

Line 656: FROM per_business_groups

652: BEGIN
653: hr_utility.trace('Enter Legislation code');
654: SELECT legislation_code
655: INTO l_legislation_code_l
656: FROM per_business_groups
657: WHERE business_group_id =p_business_group_id;
658:
659: RETURN (l_legislation_code_l);
660: hr_utility.trace('Leaving Legislation code' );

Line 716: l_legislation_code per_business_groups.legislation_code%TYPE ;

712: l_default_lang varchar2(10);
713: l_default_territory varchar2(10);
714: l_temp varchar2(500);
715: l_exception_report_id varchar2(40);
716: l_legislation_code per_business_groups.legislation_code%TYPE ;
717:
718:
719: cursor c_rtf_data(c_template_name in varchar2) is
720: Select application_short_name,template_code,default_language,default_territory