APPS.HR_GENERAL dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 1119: from per_ass_status_type_amends

1115: p_business_group_id number) return varchar2 is
1116: --
1117: cursor csr_lookup is
1118: select user_status
1119: from per_ass_status_type_amends
1120: where assignment_status_type_id = p_assignment_status_type_id
1121: and business_group_id = p_business_group_id;
1122: --
1123: v_meaning per_ass_status_type_amends.user_status%type := null; --#2555987 changed size from 30 to %type.

Line 1123: v_meaning per_ass_status_type_amends.user_status%type := null; --#2555987 changed size from 30 to %type.

1119: from per_ass_status_type_amends
1120: where assignment_status_type_id = p_assignment_status_type_id
1121: and business_group_id = p_business_group_id;
1122: --
1123: v_meaning per_ass_status_type_amends.user_status%type := null; --#2555987 changed size from 30 to %type.
1124: --
1125: begin
1126: --
1127: -- Only open the cursor if the parameter is going to retrieve anything

Line 1656: from per_ass_status_type_amends am,

1652: l_user_status varchar2(80);
1653: --
1654: cursor csr_amend_user_status is
1655: select tl.user_status
1656: from per_ass_status_type_amends am,
1657: per_ass_status_type_amends_tl tl
1658: where am.assignment_status_type_id = p_assignment_status_type_id
1659: and am.business_group_id = get_business_group_id -- Bug #2519443
1660: and am.ass_status_type_amend_id =

Line 1657: per_ass_status_type_amends_tl tl

1653: --
1654: cursor csr_amend_user_status is
1655: select tl.user_status
1656: from per_ass_status_type_amends am,
1657: per_ass_status_type_amends_tl tl
1658: where am.assignment_status_type_id = p_assignment_status_type_id
1659: and am.business_group_id = get_business_group_id -- Bug #2519443
1660: and am.ass_status_type_amend_id =
1661: tl.ass_status_type_amend_id