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.PER_PL_ASSIGNMENT dependencies on PER_ALL_ASSIGNMENTS_F

Line 26: from per_assignment_status_types paat , per_all_assignments_f paaf

22: and r_date between effective_start_date and effective_end_date;
23:
24: cursor csr_assgt_type(r_assignment_id number,r_date date) is
25: select per_system_status
26: from per_assignment_status_types paat , per_all_assignments_f paaf
27: where paat.assignment_status_type_id=paaf.assignment_status_type_id
28: and assignment_id=r_assignment_id
29: and r_date between effective_start_date and effective_end_date;
30: function get_person_id(l_assignment_id number,l_date date) return number is

Line 33: from per_all_assignments_f

29: and r_date between effective_start_date and effective_end_date;
30: function get_person_id(l_assignment_id number,l_date date) return number is
31: cursor csr_person_id is
32: select person_id
33: from per_all_assignments_f
34: where assignment_id=l_assignment_id
35: and l_date between effective_start_date and effective_end_date;
36: l_personid number;
37: begin

Line 144: -------core store this in employment_category in per_all_assignments_f table..displays it as assignment_category on UI

140:
141: hr_utility.set_location(l_proc,20);
142: ------Conditionally mandatory---------
143: --------for a normal contract,the assignment category is mandatory...
144: -------core store this in employment_category in per_all_assignments_f table..displays it as assignment_category on UI
145: if p_scl_segment3='NORMAL' then
146: hr_api.mandatory_arg_error
147: (p_api_name => l_proc,
148: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','ASSIGNMENT_CATEGORY'),

Line 361: from per_all_assignments_f

357: )is
358:
359: cursor csr_get_payroll_emp_cat is
360: select payroll_id,employment_category
361: from per_all_assignments_f
362: where assignment_id=P_ASSIGNMENT_ID
363: and P_EFFECTIVE_DATE between effective_start_date and effective_end_date;
364:
365: cursor csr_get_contract_details(r_date date) is

Line 367: from hr_soft_coding_keyflex kyflx , per_all_assignments_f paaf

363: and P_EFFECTIVE_DATE between effective_start_date and effective_end_date;
364:
365: cursor csr_get_contract_details(r_date date) is
366: select kyflx.segment3,kyflx.segment4,kyflx.segment6,fnd_date.canonical_to_date(segment13)
367: from hr_soft_coding_keyflex kyflx , per_all_assignments_f paaf
368: where paaf.assignment_id = P_ASSIGNMENT_ID
369: and paaf.soft_coding_keyflex_id= kyflx.soft_coding_keyflex_id
370: and r_date between effective_start_date and effective_end_date;
371:

Line 375: from per_all_assignments_f

371:
372: -- Bug 7041296
373: cursor csr_effective_start_date is
374: select min(effective_start_date)
375: from per_all_assignments_f
376: where assignment_id=P_ASSIGNMENT_ID;
377:
378: l_employment_category per_all_assignments_f.employment_category%type;
379: l_proc varchar2(35);

Line 378: l_employment_category per_all_assignments_f.employment_category%type;

374: select min(effective_start_date)
375: from per_all_assignments_f
376: where assignment_id=P_ASSIGNMENT_ID;
377:
378: l_employment_category per_all_assignments_f.employment_category%type;
379: l_proc varchar2(35);
380: l_assgt_type varchar2(30);
381: l_prev_assgt_type varchar2(30);
382: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;

Line 643: from per_all_assignments_f

639: l_business_group_id number(10);
640:
641: cursor csr_get_person_bus_id is
642: select person_id,business_group_id
643: from per_all_assignments_f
644: where assignment_id=p_assignment_id
645: and p_effective_date between effective_start_date and effective_end_date;
646:
647: cursor csr_sii_already_exists is

Line 724: from per_all_assignments_f

720:
721:
722: cursor csr_get_person_bus_id is
723: select person_id,business_group_id
724: from per_all_assignments_f
725: where assignment_id=p_assignment_id
726: and p_effective_date between effective_start_date and effective_end_date;
727:
728: cursor csr_paye_already_exists is

Line 860: from hr_soft_coding_keyflex keyflx,per_all_assignments_f paaf

856: ,P_EMPLOYMENT_CATEGORY in VARCHAR2) is
857:
858: cursor csr_get_contract_cat is
859: select segment3
860: from hr_soft_coding_keyflex keyflx,per_all_assignments_f paaf
861: where paaf.soft_coding_keyflex_id=keyflx.soft_coding_keyflex_id --Changed the join condition for Bug 7425845
862: and paaf.effective_start_date between effective_start_date and effective_end_date
863: and assignment_id=p_assignment_id;
864: l_contract_category hr_soft_coding_keyflex.segment3%type;

Line 981: from per_all_assignments_f

977: P_SCL_SEGMENT3 in varchar2) is
978:
979: cursor csr_business_group is
980: select business_group_id
981: from per_all_assignments_f
982: where assignment_id = p_assignment_id;
983:
984: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
985:

Line 984: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

980: select business_group_id
981: from per_all_assignments_f
982: where assignment_id = p_assignment_id;
983:
984: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
985:
986: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
987: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
988: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;

Line 1035: from per_all_assignments_f

1031:
1032:
1033: cursor csr_business_group is
1034: select business_group_id
1035: from per_all_assignments_f
1036: where assignment_id = p_assignment_id;
1037:
1038: cursor csr_segment3 is
1039: select soft.segment3

Line 1040: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf

1036: where assignment_id = p_assignment_id;
1037:
1038: cursor csr_segment3 is
1039: select soft.segment3
1040: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf
1041: where paaf.soft_coding_keyflex_id = soft.soft_coding_keyflex_id
1042: and paaf.assignment_id = p_assignment_id
1043: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1044: