APPS.PAY_FRR_DATA_PUMP dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 49: l_ass_status_typ_id per_ass_status_type_amends.assignment_status_type_id%type;

45: ,p_language_code in varchar2
46: )
47: return number is
48: --
49: l_ass_status_typ_id per_ass_status_type_amends.assignment_status_type_id%type;
50: --
51: Begin
52: If p_user_status is not null
53: and (hr_general.decode_lookup('NAME_TRANSLATIONS','STANDARD')

Line 60: ,per_ass_status_type_amends asta

56: select pas.assignment_status_type_id
57: into l_ass_status_typ_id
58: from per_assignment_status_types_tl pastl
59: ,per_assignment_status_types pas
60: ,per_ass_status_type_amends asta
61: where pas.assignment_status_type_id = pastl.assignment_status_type_id
62: and pastl.language = p_language_code
63: and nvl(asta.user_status,pastl.user_status) = p_user_status
64: and asta.assignment_status_type_id(+) = pas.assignment_status_type_id