DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_CONVERSION_TYPES_V

Line 9812: SELECT 'Y' FROM pa_conversion_types_v

9808: AND calendar_id= l_calendar_id;
9809:
9810: -- Added for Bug 5225146
9811: CURSOR l_cur_project_rate_type (l_project_rate_type VARCHAR )IS
9812: SELECT 'Y' FROM pa_conversion_types_v
9813: WHERE conversion_type <> 'User' AND user_conversion_type = l_project_rate_type;
9814:
9815: -- Added for Bug 5188246
9816: CURSOR l_cur_retention_tax_code (l_retention_tax_code VARCHAR ) IS

Line 20444: from pa_conversion_types_v

20440:
20441: begin
20442: l_USER_INV_RATE_TYPE:=l_INV_RATE_TYPE;
20443: select conversion_type into l_INV_RATE_TYPE
20444: from pa_conversion_types_v
20445: where user_conversion_type=l_USER_INV_RATE_TYPE;
20446: exception when no_data_found then
20447: l_INV_RATE_TYPE :=null;
20448: end;

Line 21034: from pa_conversion_types_v

21030: if l_INV_RATE_TYPE is not null and l_INV_RATE_TYPE <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR then
21031: begin
21032: l_USER_INV_RATE_TYPE:=l_INV_RATE_TYPE;
21033: select conversion_type into l_INV_RATE_TYPE
21034: from pa_conversion_types_v
21035: where user_conversion_type=l_USER_INV_RATE_TYPE;
21036: exception when no_data_found then
21037: l_INV_RATE_TYPE:=null;
21038: end;