eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_UTILITIES_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 616: ,per_all_assignments_f per_asg

612: --
613: cursor csr_has_vac is
614: select 1
615: from per_all_people_f per_per
616: ,per_all_assignments_f per_asg
617: ,per_vacancies per_vac
618: where per_per.party_id=p_party_id
619: and p_eff_date between per_per.effective_start_date and per_per.effective_end_date
620: and per_per.person_id=per_asg.person_id

Line 629: per_all_assignments_f paf

625: per_vac.vacancy_id in (select
626: pvla.vacancy_id
627: from
628: per_vac_linked_assignments pvla,
629: per_all_assignments_f paf
630: where
631: pvla.tgt_apl_asg_id = per_asg.assignment_id
632: and sysdate between nvl(start_date,sysdate) and nvl(sysdate,end_date)
633: and paf.assignment_id = pvla.tgt_apl_asg_id

Line 895: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;

891: l_object_version_number number;
892: l_return_status varchar2(30);
893: l_update_mode varchar2(30) := p_update_mode;
894: l_assgn_details_row irc_assignment_details_f%ROWTYPE;
895: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;
896: l_appln_tracking varchar2(1);
897: --
898: cursor c_assgn_details_row is
899: select *

Line 907: from per_all_assignments_f

903: and latest_details='Y';
904: --
905: cursor c_bg_id is
906: select business_group_id
907: from per_all_assignments_f
908: where assignment_id = p_assignment_id
909: and trunc(sysdate) between effective_start_date and effective_end_date;
910: --
911: cursor c_appln_tracking is

Line 1005: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;

1001: l_return_status varchar2(30);
1002: l_update_mode varchar2(30);
1003: l_assgn_details_row irc_assignment_details_f%ROWTYPE;
1004: l_appl_tracking varchar2(1);
1005: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;
1006:
1007: cursor c_bg_id is select business_group_id from per_all_assignments_f where assignment_id=p_assignment_id and trunc(sysdate) between effective_start_date and effective_end_date;
1008: cursor c_assgn_details_row is select * from irc_assignment_details_f where assignment_id =p_assignment_id and latest_details='Y';
1009: cursor c_assgn_details is select 1 from irc_assignment_details_f where assignment_id =p_assignment_id and sysdate between effective_start_date and effective_end_Date and latest_details='Y';

Line 1007: cursor c_bg_id is select business_group_id from per_all_assignments_f where assignment_id=p_assignment_id and trunc(sysdate) between effective_start_date and effective_end_date;

1003: l_assgn_details_row irc_assignment_details_f%ROWTYPE;
1004: l_appl_tracking varchar2(1);
1005: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;
1006:
1007: cursor c_bg_id is select business_group_id from per_all_assignments_f where assignment_id=p_assignment_id and trunc(sysdate) between effective_start_date and effective_end_date;
1008: cursor c_assgn_details_row is select * from irc_assignment_details_f where assignment_id =p_assignment_id and latest_details='Y';
1009: cursor c_assgn_details is select 1 from irc_assignment_details_f where assignment_id =p_assignment_id and sysdate between effective_start_date and effective_end_Date and latest_details='Y';
1010: cursor c_appln_tracking is select nvl(ORG_INFORMATION11,'N') from HR_ORGANIZATION_INFORMATION where organization_id=l_business_grp_id and org_information_context='BG Recruitment';
1011:

Line 1130: from per_all_assignments_f

1126: Cursor C_Assignment_details is
1127: select person_id
1128: , business_group_id
1129: , effective_start_date
1130: from per_all_assignments_f
1131: where assignment_id=p_assignment_id
1132: and sysdate between effective_start_date and effective_end_date;
1133: --
1134: Cursor C_Address_id is

Line 1377: FROM PER_ALL_ASSIGNMENTS_F asg

1373: ,asg.position_id as p_position_id
1374: ,asg.organization_id as p_organization_id
1375: ,asg.business_group_id as p_business_group_id
1376: ,pay.change_date as p_effective_date
1377: FROM PER_ALL_ASSIGNMENTS_F asg
1378: ,PER_PAY_PROPOSALS pay
1379: WHERE asg.assignment_id = p_assignment_id
1380: and pay.assignment_id = p_assignment_id
1381: and asg.effective_end_date = ( SELECT max (effective_end_date)

Line 1382: FROM per_all_assignments_f

1378: ,PER_PAY_PROPOSALS pay
1379: WHERE asg.assignment_id = p_assignment_id
1380: and pay.assignment_id = p_assignment_id
1381: and asg.effective_end_date = ( SELECT max (effective_end_date)
1382: FROM per_all_assignments_f
1383: WHERE assignment_id = p_assignment_id
1384: );
1385: --
1386: l_asg_hours_per_year NUMBER ;

Line 2398: l_manager_id per_all_assignments_f.supervisor_id%type;

2394:
2395: function is_supervisor(p_person_id in number, p_vacancy_id in number)
2396: return varchar2
2397: is
2398: l_manager_id per_all_assignments_f.supervisor_id%type;
2399: l_supervisor varchar2(5) := 'N';
2400:
2401: -- Cursor to fetch supervisors of an applicant
2402: cursor c_supervisor_id(c_managerId in number) is

Line 2404: from per_all_assignments_f paf

2400:
2401: -- Cursor to fetch supervisors of an applicant
2402: cursor c_supervisor_id(c_managerId in number) is
2403: select distinct PERSON_ID
2404: from per_all_assignments_f paf
2405: start with paf.person_id = c_managerId
2406: and sysdate between paf.effective_start_date and paf.effective_end_date
2407: and assignment_type IN ('E','A')
2408: connect by prior paf.supervisor_id = paf.person_id ;