DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_CONVERSION_TYPES_V

Line 9560: SELECT 'Y' FROM pa_conversion_types_v

9556: AND calendar_id= l_calendar_id;
9557:
9558: -- Added for Bug 5225146
9559: CURSOR l_cur_project_rate_type (l_project_rate_type VARCHAR )IS
9560: SELECT 'Y' FROM pa_conversion_types_v
9561: WHERE conversion_type <> 'User' AND user_conversion_type = l_project_rate_type;
9562:
9563: -- Added for Bug 5188246
9564: CURSOR l_cur_retention_tax_code (l_retention_tax_code VARCHAR ) IS

Line 20043: from pa_conversion_types_v

20039:
20040: begin
20041: l_USER_INV_RATE_TYPE:=l_INV_RATE_TYPE;
20042: select conversion_type into l_INV_RATE_TYPE
20043: from pa_conversion_types_v
20044: where user_conversion_type=l_USER_INV_RATE_TYPE;
20045: exception when no_data_found then
20046: l_INV_RATE_TYPE :=null;
20047: end;

Line 20633: from pa_conversion_types_v

20629: if l_INV_RATE_TYPE is not null and l_INV_RATE_TYPE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR then
20630: begin
20631: l_USER_INV_RATE_TYPE:=l_INV_RATE_TYPE;
20632: select conversion_type into l_INV_RATE_TYPE
20633: from pa_conversion_types_v
20634: where user_conversion_type=l_USER_INV_RATE_TYPE;
20635: exception when no_data_found then
20636: l_INV_RATE_TYPE:=null;
20637: end;