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_PARTY_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 1951: from per_all_assignments_f paaf

1947: ,p_effective_date IN date) IS
1948: --
1949: cursor csr_application_count(p_vacancy_id number, p_effective_date date) is
1950: select count(*)
1951: from per_all_assignments_f paaf
1952: , IRC_AGENCY_VACANCIES AGV1
1953: ,per_all_people_f per1
1954: ,irc_notification_preferences prefs
1955: where paaf.vacancy_id = p_vacancy_id and paaf.assignment_type = 'A'

Line 2030: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

2026: ,p_applicant_number OUT NOCOPY varchar2) IS
2027: --
2028: l_proc varchar2(72) := g_package||'registered_user_application';
2029: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
2030: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2031: l_person_id per_all_people_f.person_id%TYPE;
2032: l_party_id per_all_people_f.party_id%TYPE;
2033: l_rec_person_id per_all_people_f.person_id%TYPE;
2034: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 2034: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2030: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2031: l_person_id per_all_people_f.person_id%TYPE;
2032: l_party_id per_all_people_f.party_id%TYPE;
2033: l_rec_person_id per_all_people_f.person_id%TYPE;
2034: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2035: l_effective_date date;
2036: l_application_received_date date;
2037: l_party_last_update_date date;
2038: l_return_status varchar2(10);

Line 2095: l_assignment_sequence per_all_assignments_f.assignment_sequence%type;

2091: l_cagr_grade_def_id number;
2092: l_cagr_concatenated_segments varchar2(2000);
2093: l_group_name pay_people_groups.group_name%type;
2094: l_soft_coding_keyflex_id number;
2095: l_assignment_sequence per_all_assignments_f.assignment_sequence%type;
2096: -- those required for hr_applicant_api.create_applicant
2097: l_application_id number;
2098: l_full_name per_all_people_f.full_name%type;
2099: l_person_type per_person_types.system_person_type%type;

Line 2178: from per_all_assignments_f

2174: where vacancy_id = p_vacancy_id;
2175: --
2176: cursor get_new_asg(p_person_id number, p_effective_date date) is
2177: select assignment_id,object_version_number
2178: from per_all_assignments_f
2179: where person_id=p_person_id
2180: and effective_start_date = p_effective_date
2181: and assignment_type='A';
2182: --

Line 3484: ,per_all_assignments_f asg2

3480: where addr.person_id=per1.person_id
3481: and addr.address_type in ('H','REC','HOME')))
3482: and (p_manager_last_name is null
3483: or exists (select 1 from per_all_people_f per2
3484: ,per_all_assignments_f asg2
3485: where asg2.person_id=per1.person_id
3486: and asg2.assignment_type in ('E','C')
3487: and asg2.supervisor_id=per2.person_id
3488: and asg2.effective_start_date between per2.effective_start_date and per2.effective_end_date

Line 5610: per_all_assignments_f paf

5606: -- Cursor declarations
5607: cursor csr_appl is
5608: select 1
5609: from per_all_people_f ppf,
5610: per_all_assignments_f paf
5611: where ppf.party_id = p_party_id
5612: and paf.person_id = ppf.person_id
5613: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date;
5614: --Variable declarations

Line 5671: per_all_assignments_f paf,

5667: -- Cursor Declarations
5668: cursor csr_offers is
5669: select paf.assignment_id
5670: from per_all_people_f ppf,
5671: per_all_assignments_f paf,
5672: irc_offers iof,
5673: irc_offer_status_history history
5674: where ppf.party_id = p_party_id
5675: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date

Line 5722: per_all_assignments_f paf,

5718: -- Cursor declarations
5719: Cursor csr_view_all_apl_count is
5720: select count(pav.vacancy_id)
5721: from per_all_people_f ppf,
5722: per_all_assignments_f paf,
5723: per_all_vacancies pav
5724: where ppf.party_id = p_party_id
5725: and paf.person_id = ppf.person_id
5726: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date

Line 5810: per_all_assignments_f paf

5806: -- Cursor declarations
5807: cursor csr_applications is
5808: select paf.assignment_id
5809: from per_all_people_f ppf,
5810: per_all_assignments_f paf
5811: where ppf.party_id = p_target_party_id
5812: and paf.person_id = ppf.person_id
5813: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
5814: and exists (select null

Line 5816: per_all_assignments_f paf1

5812: and paf.person_id = ppf.person_id
5813: and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
5814: and exists (select null
5815: from per_all_people_f ppf1,
5816: per_all_assignments_f paf1
5817: where ppf1.party_id = p_souce_party_id
5818: and paf1.person_id = ppf1.person_id
5819: and trunc(sysdate) between paf1.effective_start_date and paf1.effective_end_date
5820: and paf.vacancy_id = nvl(paf1.vacancy_id, -99));

Line 6168: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

6164: PRAGMA autonomous_transaction;
6165: --
6166: l_proc varchar2(72) := g_package||'ofr_reg_user_application';
6167: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
6168: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
6169: l_person_id per_all_people_f.person_id%TYPE;
6170: l_party_id per_all_people_f.party_id%TYPE;
6171: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6172: l_application_received_date date;

Line 6171: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

6167: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
6168: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
6169: l_person_id per_all_people_f.person_id%TYPE;
6170: l_party_id per_all_people_f.party_id%TYPE;
6171: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
6172: l_application_received_date date;
6173: l_party_last_update_date date;
6174: l_applicant_number per_all_people_f.applicant_number%type;
6175: l_person_type_id per_person_types.person_type_id%type;

Line 6222: l_assignment_sequence per_all_assignments_f.assignment_sequence%type;

6218: l_cagr_grade_def_id number;
6219: l_cagr_concatenated_segments varchar2(2000);
6220: l_group_name pay_people_groups.group_name%type;
6221: l_soft_coding_keyflex_id number;
6222: l_assignment_sequence per_all_assignments_f.assignment_sequence%type;
6223: -- those required for hr_applicant_api.create_applicant
6224: l_application_id number;
6225: l_full_name per_all_people_f.full_name%type;
6226: l_person_type per_person_types.system_person_type%type;

Line 6295: from per_all_assignments_f

6291: and p_effective_date between effective_start_date and effective_end_date;
6292: --
6293: cursor get_new_asg(p_person_id number, p_effective_date date) is
6294: select assignment_id,object_version_number
6295: from per_all_assignments_f
6296: where person_id = p_person_id
6297: and effective_start_date = p_effective_date
6298: and assignment_type='A';
6299: --