DBA Data[Home] [Help]

APPS.PSP_GENERAL dependencies on PER_BUSINESS_GROUPS

Line 458: FROM per_business_groups_perf

454: AND effective_end_date >= low_date;
455:
456: CURSOR legislation_code_cur IS
457: SELECT legislation_code
458: FROM per_business_groups_perf
459: WHERE business_group_id = l_business_group_id;
460:
461: CURSOR wrk_sch_exists_cur IS
462: SELECT put.user_table_name,

Line 1607: CURSOR get_curr_for_bg is SELECT currency_code from per_business_groups where

1603: *****************************************************************************************/
1604: FUNCTION get_currency_code(p_business_group_id IN NUMBER ) RETURN VARCHAR2 IS
1605: l_curr_code VARCHAR2(15);
1606:
1607: CURSOR get_curr_for_bg is SELECT currency_code from per_business_groups where
1608: business_group_id=p_business_group_id;
1609:
1610:
1611: BEGIN