APPS.PAY_PROCESSING_RULE_DATA_PUMP dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 109: l_ass_status_typ_id per_assignment_status_types.assignment_status_type_id%type;

105: ,p_effective_date in date
106: )
107: return number is
108: --
109: l_ass_status_typ_id per_assignment_status_types.assignment_status_type_id%type;
110:
111: invalid_status_stnd exception;
112: invalid_status_badjust exception;
113: l_message varchar2(10000);

Line 147: from per_assignment_status_types_tl astpl,

143: raise invalid_status_badjust;
144: else
145: select astp.assignment_status_type_id
146: into l_ass_status_typ_id
147: from per_assignment_status_types_tl astpl,
148: per_assignment_status_types astp
149: where astpl.assignment_status_type_id = astp.assignment_status_type_id
150: and UPPER(astpl.user_status) = UPPER(p_assignment_status)
151: and nvl(astp.business_group_id,nvl(p_business_group_id,0))

Line 148: per_assignment_status_types astp

144: else
145: select astp.assignment_status_type_id
146: into l_ass_status_typ_id
147: from per_assignment_status_types_tl astpl,
148: per_assignment_status_types astp
149: where astpl.assignment_status_type_id = astp.assignment_status_type_id
150: and UPPER(astpl.user_status) = UPPER(p_assignment_status)
151: and nvl(astp.business_group_id,nvl(p_business_group_id,0))
152: = nvl(p_business_group_id,0)