APPS.PQP_EXR_SWI dependencies on PER_BUSINESS_GROUPS

Line 557: l_legislation_code_l per_business_groups.legislation_code%TYPE;

553: -- ----------------------------------------------------------------------------
554: FUNCTION get_legislation_code (p_business_group_id IN NUMBER)
555: RETURN VARCHAR2
556: IS
557: l_legislation_code_l per_business_groups.legislation_code%TYPE;
558: BEGIN
559: hr_utility.trace('Enter Legislation code');
560: SELECT legislation_code
561: INTO l_legislation_code_l

Line 562: FROM per_business_groups

558: BEGIN
559: hr_utility.trace('Enter Legislation code');
560: SELECT legislation_code
561: INTO l_legislation_code_l
562: FROM per_business_groups
563: WHERE business_group_id =p_business_group_id;
564:
565: RETURN (l_legislation_code_l);
566: hr_utility.trace('Leaving Legislation code' );

Line 622: l_legislation_code per_business_groups.legislation_code%TYPE ;

618: l_default_lang varchar2(10);
619: l_default_territory varchar2(10);
620: l_temp varchar2(500);
621: l_exception_report_id varchar2(40);
622: l_legislation_code per_business_groups.legislation_code%TYPE ;
623:
624:
625: cursor c_rtf_data(c_template_name in varchar2) is
626: Select application_short_name,template_code,default_language,default_territory