DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on FND_RESPONSIBILITY_VL

Line 1627: fnd_responsibility_vl fr,

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)
1631: and fur.responsibility_id = fr.responsibility_id

Line 1653: fnd_responsibility_vl fr,

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
1657: and fr.start_date < sysdate

Line 1678: fnd_responsibility_vl fr,

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
1682: fr.responsibility_id = x_resp_id and