APPS.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on FND_PROFILE

Line 17: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN

13: old_org_id NUMBER) IS
14:
15: x_salesrep_name cn_salesreps.name%TYPE;
16: BEGIN
17: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN
18: SELECT name
19: INTO x_salesrep_name
20: FROM cn_salesreps
21: WHERE salesrep_id = old_salesrep_id

Line 46: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN

42: new_org_id NUMBER) IS
43:
44: x_salesrep_name cn_salesreps.name%TYPE;
45: BEGIN
46: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN
47: SELECT name
48: INTO x_salesrep_name
49: FROM cn_salesreps
50: WHERE salesrep_id = new_salesrep_id

Line 80: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN

76: new_org_id NUMBER) IS
77:
78: x_salesrep_name cn_salesreps.name%TYPE;
79: BEGIN
80: IF fnd_profile.value('CN_MARK_EVENTS') = 'Y' THEN
81: SELECT name
82: INTO x_salesrep_name
83: FROM cn_salesreps
84: WHERE salesrep_id = new_salesrep_id