APPS.PER_PL_ASSIGNMENT dependencies on HR_SOFT_CODING_KEYFLEX

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 387: l_contract_category hr_soft_coding_keyflex.segment3%type;

383: l_tax_office per_all_people_f.per_information6%TYPE;
384: l_one number(1);
385: l_join_variable number(10);
386: l_payroll_id number(10);
387: l_contract_category hr_soft_coding_keyflex.segment3%type;
388: l_contract_type hr_soft_coding_keyflex.segment4%type;
389: l_contract_change_reason hr_soft_coding_keyflex.segment6%type;
390: l_contract_type_change_date date;
391: l_person_id number(10) ;

Line 388: l_contract_type hr_soft_coding_keyflex.segment4%type;

384: l_one number(1);
385: l_join_variable number(10);
386: l_payroll_id number(10);
387: l_contract_category hr_soft_coding_keyflex.segment3%type;
388: l_contract_type hr_soft_coding_keyflex.segment4%type;
389: l_contract_change_reason hr_soft_coding_keyflex.segment6%type;
390: l_contract_type_change_date date;
391: l_person_id number(10) ;
392: l_asg_min_start_date date ;

Line 389: l_contract_change_reason hr_soft_coding_keyflex.segment6%type;

385: l_join_variable number(10);
386: l_payroll_id number(10);
387: l_contract_category hr_soft_coding_keyflex.segment3%type;
388: l_contract_type hr_soft_coding_keyflex.segment4%type;
389: l_contract_change_reason hr_soft_coding_keyflex.segment6%type;
390: l_contract_type_change_date date;
391: l_person_id number(10) ;
392: l_asg_min_start_date date ;
393:

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 864: l_contract_category hr_soft_coding_keyflex.segment3%type;

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;
865: l_join_variable number(10);
866: l_assgt_type per_assignment_status_types.per_system_status%type;
867: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;
868: l_tax_office per_all_people_f.per_information6%TYPE;

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:

Line 1052: l_segment3 hr_soft_coding_keyflex.segment3%TYPE;

1048: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1049: l_effective_date_warning boolean;
1050: l_record_exists varchar2(1);
1051: l_business_group_id pay_pl_paye_details_f.business_group_id%TYPE;
1052: l_segment3 hr_soft_coding_keyflex.segment3%TYPE;
1053: l_proc varchar2(19);
1054: cursor csr_paye_exists is
1055: select '1'
1056: from pay_pl_paye_details_f