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 561: (i.legislation_code IS NULL AND i.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))

557: ,pay_user_rows_f r
558: ,pay_user_columns c
559: ,pay_user_tables t
560: WHERE ((i.legislation_code = 'AE' AND i.business_group_id IS NULL) OR
561: (i.legislation_code IS NULL AND i.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))
562: AND ((r.legislation_code = 'AE' AND r.business_group_id IS NULL) OR
563: (r.legislation_code IS NULL AND r.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))
564: AND c.legislation_code = 'AE'
565: AND t.legislation_code = 'AE'

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

559: ,pay_user_tables t
560: WHERE ((i.legislation_code = 'AE' AND i.business_group_id IS NULL) OR
561: (i.legislation_code IS NULL AND i.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))
562: AND ((r.legislation_code = 'AE' AND r.business_group_id IS NULL) OR
563: (r.legislation_code IS NULL AND r.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')))
564: AND c.legislation_code = 'AE'
565: AND t.legislation_code = 'AE'
566: AND UPPER(t.user_table_name) = UPPER('AE_TERMINATION_INITIATOR')
567: AND t.user_table_id = r.user_table_id