APPS.PER_OTHERBG_APL_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 26: from per_assignment_status_types

22: and papf.person_id = paaf.person_id;
23:
24: cursor csr_get_irc_asg_status(bg_id number) is
25: select assignment_status_type_id
26: from per_assignment_status_types
27: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
28: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y';
29: -- and (business_group_id is null or
30: -- business_group_id = bg_id);

Line 34: from per_assignment_status_types

30: -- business_group_id = bg_id);
31:
32: cursor csr_get_per_asg_status(bg_id number) is
33: select assignment_status_type_id
34: from per_assignment_status_types
35: where PER_SYSTEM_STATUS= 'TERM_APL'
36: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y'
37: and (business_group_id is null or
38: business_group_id = bg_id);

Line 64: l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;

60: l_person_id per_all_assignments_f.person_id%type;
61: a_object_version_number per_all_assignments_f.object_version_number%TYPE;
62: l_object_version_number per_all_people_f.object_version_number%TYPE;
63: l_business_group_id per_all_people_f.business_group_id%TYPE;
64: l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
65: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
66:
67: i_assignment_status_id irc_assignment_statuses.assignment_id%type;
68: i_object_version_number irc_assignment_statuses.object_version_number%type;

Line 65: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;

61: a_object_version_number per_all_assignments_f.object_version_number%TYPE;
62: l_object_version_number per_all_people_f.object_version_number%TYPE;
63: l_business_group_id per_all_people_f.business_group_id%TYPE;
64: l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
65: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
66:
67: i_assignment_status_id irc_assignment_statuses.assignment_id%type;
68: i_object_version_number irc_assignment_statuses.object_version_number%type;
69:

Line 401: from per_assignment_status_types

397:
398: --- Fix For Bug # 12654541 ---
399: cursor csr_get_irc_asg_status(bg_id number) is
400: select assignment_status_type_id
401: from per_assignment_status_types
402: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
403: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y'
404: and (business_group_id is null or
405: business_group_id = bg_id);

Line 408: per_assignment_status_types.assignment_status_type_id%TYPE) is

404: and (business_group_id is null or
405: business_group_id = bg_id);
406:
407: cursor irc_asg_status(l_asg_status_type_id
408: per_assignment_status_types.assignment_status_type_id%TYPE) is
409: select iass.assignment_status_id, iass.object_version_number
410: from irc_assignment_statuses iass
411: where iass.assignment_status_id =
412: (select max(iass.assignment_status_id)

Line 417: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;

413: from irc_assignment_statuses iass
414: where iass.assignment_id = apl_assignment_id
415: and iass.assignment_status_type_id = l_asg_status_type_id);
416:
417: i_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%TYPE;
418: l_asg_status_id irc_assignment_statuses.assignment_status_id%type;
419: l_asg_status_ovn irc_assignment_statuses.object_version_number%type;
420: --- Fix For Bug # 12654541 ---
421: