DBA Data[Home] [Help]

APPS.PAY_WF_PKG dependencies on PER_BUSINESS_GROUPS

Line 929: from per_business_groups

925: */
926:
927: Begin
928: select currency_code into lv_currency_code
929: from per_business_groups
930: where business_group_id = p_business_group_id;
931: Exception when others then
932: hr_utility.trace('In exception: OTHERS ');
933: null;

Line 941: PER_BUSINESS_GROUPS BG

937:
938: Begin
939: SELECT to_char(PPT.PAYMENT_TYPE_ID) into ln_nacha_payment_type_id
940: FROM PAY_PAYMENT_TYPES PPT,
941: PER_BUSINESS_GROUPS BG
942: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
943: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
944: OR PPT.TERRITORY_CODE IS NULL)
945: AND BG.BUSINESS_GROUP_ID= p_business_group_id

Line 959: PER_BUSINESS_GROUPS BG

955: Begin
956: SELECT to_char(PPT.PAYMENT_TYPE_ID)
957: into ln_check_payment_type_id
958: FROM PAY_PAYMENT_TYPES PPT,
959: PER_BUSINESS_GROUPS BG
960: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
961: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
962: OR PPT.TERRITORY_CODE IS NULL)
963: AND BG.BUSINESS_GROUP_ID= p_business_group_id

Line 2550: per_business_groups p

2546: --bug 12704242
2547: cursor cur_retropay_definition is
2548: select prd.retro_definition_id
2549: from pay_retro_definitions prd,
2550: per_business_groups p
2551: where prd.legislation_code = p.legislation_code
2552: and p.business_group_id = p_business_group_id;
2553:
2554:

Line 2652: from per_business_groups

2648: */
2649:
2650: Begin
2651: select currency_code into lv_currency_code
2652: from per_business_groups
2653: where business_group_id = p_business_group_id;
2654: Exception when others then
2655: hr_utility.trace('In exception: OTHERS ');
2656: null;

Line 2664: PER_BUSINESS_GROUPS BG

2660:
2661: Begin
2662: SELECT to_char(PPT.PAYMENT_TYPE_ID) into ln_nacha_payment_type_id
2663: FROM PAY_PAYMENT_TYPES PPT,
2664: PER_BUSINESS_GROUPS BG
2665: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
2666: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
2667: OR PPT.TERRITORY_CODE IS NULL)
2668: AND BG.BUSINESS_GROUP_ID= p_business_group_id

Line 2682: PER_BUSINESS_GROUPS BG

2678: Begin
2679: SELECT to_char(PPT.PAYMENT_TYPE_ID)
2680: into ln_check_payment_type_id
2681: FROM PAY_PAYMENT_TYPES PPT,
2682: PER_BUSINESS_GROUPS BG
2683: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
2684: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
2685: OR PPT.TERRITORY_CODE IS NULL)
2686: AND BG.BUSINESS_GROUP_ID= p_business_group_id