APPS.HR_GENERAL dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 1121: from per_ass_status_type_amends

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

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

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

Line 1658: from per_ass_status_type_amends am,

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

Line 1659: per_ass_status_type_amends_tl tl

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