APPS.PQP_PRORATION_WRAPPER dependencies on PER_BUSINESS_GROUPS

Line 6: FROM per_business_groups

2: /* $Header: pqprowiz.pkb 115.15 2002/03/17 10:51:15 pkm ship $ */
3:
4: CURSOR c_biz_group(p_business_group_name IN VARCHAR2) IS
5: SELECT business_group_id
6: FROM per_business_groups
7: WHERE UPPER(name) = UPPER(p_business_group_name);
8:
9: CURSOR c_dated_pay_table(p_table_name IN VARCHAR2) IS
10: SELECT dated_table_id

Line 78: PROCEDURE valid_business_group(p_business_group_name IN per_business_groups.name%TYPE)

74: --*************************************************************************
75: -- Procedure : Valid business group
76: --*************************************************************************
77:
78: PROCEDURE valid_business_group(p_business_group_name IN per_business_groups.name%TYPE)
79: AS
80: l_exists varchar2(2) := 'N';
81: lv_procedure_name VArchar2(80) := '.valid_business_group';
82: BEGIN

Line 90: FROM PER_BUSINESS_GROUPS

86: INTO l_exists
87: FROM dual
88: WHERE EXISTS
89: (SELECT null
90: FROM PER_BUSINESS_GROUPS
91: WHERE name = p_business_group_name
92: );
93: EXCEPTION
94: WHEN NO_DATA_FOUND THEN