DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on FND_USER_RESP_GROUPS

Line 1626: from fnd_user_resp_groups fur,

1622:
1623: BEGIN
1624: select MIN(fr.responsibility_id)
1625: into x_resp_id
1626: from fnd_user_resp_groups fur,
1627: fnd_responsibility_vl fr,
1628: financials_system_parameters fsp
1629: where fur.user_id = x_user_id
1630: and fur.responsibility_application_id in (x_ip_resp_appl_id, x_po_resp_appl_id)

Line 1652: from fnd_user_resp_groups fur,

1648: if ((x_resp_id = -1) or (x_resp_id is null)) THEN
1649: BEGIN
1650: select MIN(fr.responsibility_id)
1651: into x_resp_id
1652: from fnd_user_resp_groups fur,
1653: fnd_responsibility_vl fr,
1654: financials_system_parameters fsp
1655: where fur.user_id = x_user_id
1656: and fur.responsibility_id = fr.responsibility_id

Line 1677: FROM fnd_user_resp_groups fur,

1673: if(x_resp_id <> -1) then
1674: BEGIN
1675: SELECT MIN(responsibility_application_id)
1676: INTO x_resp_appl_id
1677: FROM fnd_user_resp_groups fur,
1678: fnd_responsibility_vl fr,
1679: financials_system_parameters fsp
1680: WHERE
1681: fur.responsibility_id = fr.responsibility_id and