DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on FND_RESPONSIBILITY_VL

Line 1625: fnd_responsibility_vl fr,

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

Line 1650: fnd_responsibility_vl fr,

1646: BEGIN
1647: select MIN(fr.responsibility_id)
1648: into x_resp_id
1649: from fnd_user_resp_groups fur,
1650: fnd_responsibility_vl fr,
1651: financials_system_parameters fsp
1652: where fur.user_id = x_user_id
1653: and fur.responsibility_id = fr.responsibility_id
1654: and fr.start_date < sysdate

Line 1675: fnd_responsibility_vl fr,

1671: BEGIN
1672: SELECT MIN(responsibility_application_id)
1673: INTO x_resp_appl_id
1674: FROM fnd_user_resp_groups fur,
1675: fnd_responsibility_vl fr,
1676: financials_system_parameters fsp
1677: WHERE
1678: fur.responsibility_id = fr.responsibility_id and
1679: fr.responsibility_id = x_resp_id and