APPS.CSM_HZ_LOCATION_PKG dependencies on ASG_USER

Line 46: FROM asg_user WHERE user_name=p_user_name;

42: BEGIN
43:
44: SELECT user_id,responsibility_id, app_id ,org_id,resource_id
45: INTO l_user_id,l_resp_id,l_app_id,l_org_id,l_rs_id
46: FROM asg_user WHERE user_name=p_user_name;
47:
48: fnd_global.apps_initialize(l_user_id, l_resp_id, l_app_id);
49: --mo_global.set_policy_context('S',l_org_id); also done by CSP api ..so leave it to them
50: MO_GLOBAL.INIT ('CSM');

Line 107: FROM ASG_USER asg,

103:
104: CURSOR c_get_party_id (c_user VARCHAR2)
105: IS
106: SELECT PERSON_PARTY_ID
107: FROM ASG_USER asg,
108: FND_USER fnd
109: WHERE asg.USER_NAME = c_user
110: AND fnd.USER_ID = asg.USER_ID;
111:

Line 109: WHERE asg.USER_NAME = c_user

105: IS
106: SELECT PERSON_PARTY_ID
107: FROM ASG_USER asg,
108: FND_USER fnd
109: WHERE asg.USER_NAME = c_user
110: AND fnd.USER_ID = asg.USER_ID;
111:
112: CURSOR c_req_hdr(b_uid VARCHAR2,tid number,lid number)
113: IS

Line 110: AND fnd.USER_ID = asg.USER_ID;

106: SELECT PERSON_PARTY_ID
107: FROM ASG_USER asg,
108: FND_USER fnd
109: WHERE asg.USER_NAME = c_user
110: AND fnd.USER_ID = asg.USER_ID;
111:
112: CURSOR c_req_hdr(b_uid VARCHAR2,tid number,lid number)
113: IS
114: SELECT TASK_ASSIGNMENT_ID FROM CSM_REQ_HEADERS_INQ