DBA Data[Home] [Help]

APPS.PAY_SOE_UTIL dependencies on FND_PROFILE

Line 18: where organization_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

14: , org_information9 balances1
15: , org_information10 balances2
16: , org_information11 balances3
17: from hr_organization_information
18: where organization_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
19: and org_information_context = 'Business Group:SOE Information'
20: and org_information1 = fnd_profile.value('PAY_SOE_USER_CATEGORY');
21: --
22: l_config config%ROWTYPE;

Line 20: and org_information1 = fnd_profile.value('PAY_SOE_USER_CATEGORY');

16: , org_information11 balances3
17: from hr_organization_information
18: where organization_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
19: and org_information_context = 'Business Group:SOE Information'
20: and org_information1 = fnd_profile.value('PAY_SOE_USER_CATEGORY');
21: --
22: l_config config%ROWTYPE;
23: --
24: TYPE dataValueRecType is RECORD (colName varchar2(30)

Line 273: select fnd_profile.value('PER_BUSINESS_GROUP_ID') into l_bgid from dual ;

269: l_init varchar2(10);
270: --
271: begin
272:
273: select fnd_profile.value('PER_BUSINESS_GROUP_ID') into l_bgid from dual ;
274: select fnd_profile.value('PAY_SOE_USER_CATEGORY') into l_soe_user_cat from dual ;
275:
276: if initialized = true then
277: l_init := 'true';

Line 274: select fnd_profile.value('PAY_SOE_USER_CATEGORY') into l_soe_user_cat from dual ;

270: --
271: begin
272:
273: select fnd_profile.value('PER_BUSINESS_GROUP_ID') into l_bgid from dual ;
274: select fnd_profile.value('PAY_SOE_USER_CATEGORY') into l_soe_user_cat from dual ;
275:
276: if initialized = true then
277: l_init := 'true';
278: else