DBA Data[Home] [Help]

APPS.PAY_WF_PKG dependencies on PER_BUSINESS_GROUPS

Line 661: from per_business_groups

657: */
658:
659: Begin
660: select currency_code into lv_currency_code
661: from per_business_groups
662: where business_group_id = p_business_group_id;
663: Exception when others then
664: hr_utility.trace('In exception: OTHERS ');
665: null;

Line 673: PER_BUSINESS_GROUPS BG

669:
670: Begin
671: SELECT to_char(PPT.PAYMENT_TYPE_ID) into ln_nacha_payment_type_id
672: FROM PAY_PAYMENT_TYPES PPT,
673: PER_BUSINESS_GROUPS BG
674: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
675: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
676: OR PPT.TERRITORY_CODE IS NULL)
677: AND BG.BUSINESS_GROUP_ID= p_business_group_id

Line 691: PER_BUSINESS_GROUPS BG

687: Begin
688: SELECT to_char(PPT.PAYMENT_TYPE_ID)
689: into ln_check_payment_type_id
690: FROM PAY_PAYMENT_TYPES PPT,
691: PER_BUSINESS_GROUPS BG
692: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
693: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
694: OR PPT.TERRITORY_CODE IS NULL)
695: AND BG.BUSINESS_GROUP_ID= p_business_group_id