APPS.CSM_UTIL_PKG dependencies on FND_APPLICATION

Line 741: fnd_application fnd_app,

737: select fnd_user_resp.user_id
738: from asg_pub_responsibility asg_resp,
739: asg_pub,
740: fnd_user_resp_groups fnd_user_resp,
741: fnd_application fnd_app,
742: jtf_rs_resource_extns res
743: where asg_resp.pub_id = asg_pub.pub_id
744: and asg_pub.name = 'SERVICEP'
745: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id

Line 791: fnd_application fnd_app

787: select fnd_user_resp.user_id
788: from asg_pub_responsibility asg_resp,
789: asg_pub,
790: fnd_user_resp_groups fnd_user_resp,
791: fnd_application fnd_app
792: where asg_resp.pub_id = asg_pub.pub_id
793: and asg_pub.name = 'SERVICEP'
794: and asg_resp.responsibility_id = fnd_user_resp.responsibility_id
795: and fnd_app.application_id = fnd_user_resp.responsibility_application_id

Line 1762: FROM FND_RESPONSIBILITY resp, fnd_application app

1758: l_application_id NUMBER;
1759:
1760: CURSOR l_get_resp_id IS
1761: SELECT resp.APPLICATION_ID, resp.RESPONSIBILITY_ID
1762: FROM FND_RESPONSIBILITY resp, fnd_application app
1763: WHERE resp.RESPONSIBILITY_KEY = 'OMFS_PALM'
1764: AND SYSDATE BETWEEN nvl(resp.start_date, sysdate) AND nvl(resp.end_date, sysdate)
1765: AND app.application_id = resp.application_id
1766: AND app.application_short_name = 'CSM';