APPS.PER_ASS_STATUSES_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS_TL

Line 147: from per_ass_status_type_amends_tl atl,

143: t.assignment_status_type_id
144: and a.business_group_id + 0 = P_BUSINESS_GROUP_ID);
145: CURSOR C2 IS
146: select 1
147: from per_ass_status_type_amends_tl atl,
148: per_ass_status_type_amends a
149: where upper(atl.user_status) = upper(P_USER_STATUS)
150: and a.business_group_id + 0 = P_BUSINESS_GROUP_ID
151: and a.ass_status_type_amend_id = atl.ass_status_type_amend_id

Line 201: update per_ass_status_type_amends_tl atl

197: a.created_by = P_CREATED_BY,
198: a.creation_date = P_CREATION_DATE
199: where a.ass_status_type_amend_id = P_ASS_STATUS_TYPE_ID;
200: --MLS
201: update per_ass_status_type_amends_tl atl
202: set atl.user_status = P_USER_STATUS,
203: atl.last_update_date = P_LAST_UPDATE_DATE,
204: atl.last_updated_by = P_LAST_UPDATED_BY,
205: atl.last_update_login = P_LAST_UPDATE_LOGIN,

Line 260: insert into per_ass_status_type_amends_tl(

256: P_LAST_UPDATE_LOGIN,
257: P_CREATED_BY,
258: P_CREATION_DATE);
259: -- MLS
260: insert into per_ass_status_type_amends_tl(
261: ASS_STATUS_TYPE_AMEND_ID,
262: LANGUAGE,
263: SOURCE_LANG,
264: USER_STATUS,

Line 891: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (

887: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
888: and (SUBB.USER_STATUS <> SUBT.USER_STATUS
889: ));
890: */
891: insert into PER_ASS_STATUS_TYPE_AMENDS_TL (
892: ASS_STATUS_TYPE_AMEND_ID,
893: USER_STATUS,
894: LAST_UPDATE_DATE,
895: LAST_UPDATED_BY,

Line 911: from PER_ASS_STATUS_TYPE_AMENDS_TL B, FND_LANGUAGES L

907: B.CREATED_BY,
908: B.CREATION_DATE,
909: L.LANGUAGE_CODE,
910: B.SOURCE_LANG
911: from PER_ASS_STATUS_TYPE_AMENDS_TL B, FND_LANGUAGES L
912: where L.INSTALLED_FLAG in ('I', 'B')
913: and B.LANGUAGE = userenv('LANG')
914: and not exists
915: (select NULL

Line 916: from PER_ASS_STATUS_TYPE_AMENDS_TL T

912: where L.INSTALLED_FLAG in ('I', 'B')
913: and B.LANGUAGE = userenv('LANG')
914: and not exists
915: (select NULL
916: from PER_ASS_STATUS_TYPE_AMENDS_TL T
917: where T.ASS_STATUS_TYPE_AMEND_ID = B.ASS_STATUS_TYPE_AMEND_ID
918: and T.LANGUAGE = L.LANGUAGE_CODE);
919: --
920: end ADD_LANGUAGE;