DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on FND_PROFILE

Line 17: l_organization_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

13: function local_nationality_not_defined return varchar2
14: is
15: begin
16: BEGIN
17: l_organization_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
18: Select Org_Information1
19: Into l_nationality_cd
20: From HR_ORGANIZATION_INFORMATION
21: Where ORG_INFORMATION_CONTEXT = 'AE_BG_DETAILS'

Line 495: (i.legislation_code IS NULL AND i.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))

491: ,pay_user_rows_f r
492: ,pay_user_columns c
493: ,pay_user_tables t
494: WHERE ((i.legislation_code = 'AE' AND i.business_group_id IS NULL) OR
495: (i.legislation_code IS NULL AND i.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))
496: AND ((r.legislation_code = 'AE' AND r.business_group_id IS NULL) OR
497: (r.legislation_code IS NULL AND r.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))
498: AND c.legislation_code = 'AE'
499: AND t.legislation_code = 'AE'

Line 497: (r.legislation_code IS NULL AND r.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))

493: ,pay_user_tables t
494: WHERE ((i.legislation_code = 'AE' AND i.business_group_id IS NULL) OR
495: (i.legislation_code IS NULL AND i.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))
496: AND ((r.legislation_code = 'AE' AND r.business_group_id IS NULL) OR
497: (r.legislation_code IS NULL AND r.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))
498: AND c.legislation_code = 'AE'
499: AND t.legislation_code = 'AE'
500: AND UPPER(t.user_table_name) = UPPER('AE_TERMINATION_INITIATOR')
501: AND t.user_table_id = r.user_table_id