DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 1626: financials_system_parameters fsp

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

Line 1651: financials_system_parameters fsp

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
1655: and nvl(fr.end_date, sysdate +1) >= sysdate

Line 1676: financials_system_parameters fsp

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
1680: fur.user_id = x_user_id and