DBA Data[Home] [Help]

APPS.EGO_PUB_FWK_PK dependencies on FND_USER

Line 1978: from FND_USER_RESP_GROUPS_DIRECT gd,

1974: ,p_message => 'user_id :' || l_user_id || ', resp_id: ' || l_resp_id);
1975:
1976: select rkey into l_resp_key from (
1977: select r.responsibility_key rkey
1978: from FND_USER_RESP_GROUPS_DIRECT gd,
1979: fnd_responsibility r,
1980: fnd_user u
1981: where gd.responsibility_id = r.responsibility_id
1982: and gd.responsibility_application_id = r.application_id

Line 1980: fnd_user u

1976: select rkey into l_resp_key from (
1977: select r.responsibility_key rkey
1978: from FND_USER_RESP_GROUPS_DIRECT gd,
1979: fnd_responsibility r,
1980: fnd_user u
1981: where gd.responsibility_id = r.responsibility_id
1982: and gd.responsibility_application_id = r.application_id
1983: and gd.user_id = u.user_id
1984: and (gd.end_date > sysdate or gd.end_date is null)

Line 1989: from FND_USER_RESP_GROUPS_INDIRECT gi,

1985: and u.user_id = l_user_id
1986: and r.responsibility_id = l_resp_id
1987: union all
1988: select r.responsibility_key rkey
1989: from FND_USER_RESP_GROUPS_INDIRECT gi,
1990: fnd_responsibility r,
1991: fnd_user u
1992: where gi.responsibility_id = r.responsibility_id
1993: and gi.responsibility_application_id = r.application_id

Line 1991: fnd_user u

1987: union all
1988: select r.responsibility_key rkey
1989: from FND_USER_RESP_GROUPS_INDIRECT gi,
1990: fnd_responsibility r,
1991: fnd_user u
1992: where gi.responsibility_id = r.responsibility_id
1993: and gi.responsibility_application_id = r.application_id
1994: and gi.user_id = u.user_id
1995: and (gi.end_date > sysdate or gi.end_date is null)

Line 2685: FROM fnd_user WHERE user_id = l_user_id;

2681: end if;
2682: -- end of privileges validation
2683:
2684: SELECT nvl(customer_id , person_party_id) into l_party_id
2685: FROM fnd_user WHERE user_id = l_user_id;
2686:
2687: SAVEPOINT PUB_BAT_STATUS_CHANGE;
2688: update EGO_PUB_BAT_HDR_B set PUBLISHED_BY = l_party_id, BATCH_CREATION_DATE = sysdate
2689: where batch_id = l_batch_id;

Line 3071: FROM fnd_user WHERE user_id = l_user_id;

3067: -- end of input validation
3068:
3069: if (p_submit_flag ) then
3070: SELECT nvl(customer_id , person_party_id) into l_party_id
3071: FROM fnd_user WHERE user_id = l_user_id;
3072: l_submit_date := sysdate ;
3073: else
3074: l_party_id := null;
3075: l_submit_date := null;