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 HR_SOFT_CODING_KEYFLEX

Line 376: from hr_soft_coding_keyflex kyflx , per_all_assignments_f paaf

372: and P_EFFECTIVE_DATE between effective_start_date and effective_end_date;
373:
374: cursor csr_get_contract_details(r_date date) is
375: select kyflx.segment3,kyflx.segment4,kyflx.segment6,fnd_date.canonical_to_date(segment13)
376: from hr_soft_coding_keyflex kyflx , per_all_assignments_f paaf
377: where paaf.assignment_id = P_ASSIGNMENT_ID
378: and paaf.soft_coding_keyflex_id= kyflx.soft_coding_keyflex_id
379: and r_date between effective_start_date and effective_end_date;
380:

Line 392: from hr_soft_coding_keyflex kyflx , per_all_assignments_f paaf

388: -- Modified for Bug 7554037
389: cursor csr_get_segment_details(r_date date) is
390: select kyflx.segment3,kyflx.segment4,kyflx.segment5,kyflx.segment11,kyflx.segment12,kyflx.segment13,
391: kyflx.segment14,kyflx.segment15,kyflx.segment16
392: from hr_soft_coding_keyflex kyflx , per_all_assignments_f paaf
393: where paaf.assignment_id = P_ASSIGNMENT_ID
394: and paaf.soft_coding_keyflex_id= kyflx.soft_coding_keyflex_id
395: and r_date between effective_start_date and effective_end_date;
396:

Line 413: l_contract_category hr_soft_coding_keyflex.segment3%type;

409: l_tax_office per_all_people_f.per_information6%TYPE;
410: l_one number(1);
411: l_join_variable number(10);
412: l_payroll_id number(10);
413: l_contract_category hr_soft_coding_keyflex.segment3%type;
414: l_contract_type hr_soft_coding_keyflex.segment4%type;
415: l_contract_change_reason hr_soft_coding_keyflex.segment6%type;
416: l_contract_type_change_date date;
417: l_person_id number(10) ;

Line 414: l_contract_type hr_soft_coding_keyflex.segment4%type;

410: l_one number(1);
411: l_join_variable number(10);
412: l_payroll_id number(10);
413: l_contract_category hr_soft_coding_keyflex.segment3%type;
414: l_contract_type hr_soft_coding_keyflex.segment4%type;
415: l_contract_change_reason hr_soft_coding_keyflex.segment6%type;
416: l_contract_type_change_date date;
417: l_person_id number(10) ;
418: l_asg_min_start_date date ;

Line 415: l_contract_change_reason hr_soft_coding_keyflex.segment6%type;

411: l_join_variable number(10);
412: l_payroll_id number(10);
413: l_contract_category hr_soft_coding_keyflex.segment3%type;
414: l_contract_type hr_soft_coding_keyflex.segment4%type;
415: l_contract_change_reason hr_soft_coding_keyflex.segment6%type;
416: l_contract_type_change_date date;
417: l_person_id number(10) ;
418: l_asg_min_start_date date ;
419: -- Added for Bug 7510498

Line 420: l_segment3 hr_soft_coding_keyflex.segment3%type;

416: l_contract_type_change_date date;
417: l_person_id number(10) ;
418: l_asg_min_start_date date ;
419: -- Added for Bug 7510498
420: l_segment3 hr_soft_coding_keyflex.segment3%type;
421: l_segment4 hr_soft_coding_keyflex.segment4%type;
422: l_segment5 hr_soft_coding_keyflex.segment5%type;
423: l_segment11 hr_soft_coding_keyflex.segment11%type;
424: l_segment12 hr_soft_coding_keyflex.segment12%type;

Line 421: l_segment4 hr_soft_coding_keyflex.segment4%type;

417: l_person_id number(10) ;
418: l_asg_min_start_date date ;
419: -- Added for Bug 7510498
420: l_segment3 hr_soft_coding_keyflex.segment3%type;
421: l_segment4 hr_soft_coding_keyflex.segment4%type;
422: l_segment5 hr_soft_coding_keyflex.segment5%type;
423: l_segment11 hr_soft_coding_keyflex.segment11%type;
424: l_segment12 hr_soft_coding_keyflex.segment12%type;
425: l_segment13 hr_soft_coding_keyflex.segment13%type;

Line 422: l_segment5 hr_soft_coding_keyflex.segment5%type;

418: l_asg_min_start_date date ;
419: -- Added for Bug 7510498
420: l_segment3 hr_soft_coding_keyflex.segment3%type;
421: l_segment4 hr_soft_coding_keyflex.segment4%type;
422: l_segment5 hr_soft_coding_keyflex.segment5%type;
423: l_segment11 hr_soft_coding_keyflex.segment11%type;
424: l_segment12 hr_soft_coding_keyflex.segment12%type;
425: l_segment13 hr_soft_coding_keyflex.segment13%type;
426: l_segment14 hr_soft_coding_keyflex.segment14%type;

Line 423: l_segment11 hr_soft_coding_keyflex.segment11%type;

419: -- Added for Bug 7510498
420: l_segment3 hr_soft_coding_keyflex.segment3%type;
421: l_segment4 hr_soft_coding_keyflex.segment4%type;
422: l_segment5 hr_soft_coding_keyflex.segment5%type;
423: l_segment11 hr_soft_coding_keyflex.segment11%type;
424: l_segment12 hr_soft_coding_keyflex.segment12%type;
425: l_segment13 hr_soft_coding_keyflex.segment13%type;
426: l_segment14 hr_soft_coding_keyflex.segment14%type;
427: l_segment15 hr_soft_coding_keyflex.segment15%type;

Line 424: l_segment12 hr_soft_coding_keyflex.segment12%type;

420: l_segment3 hr_soft_coding_keyflex.segment3%type;
421: l_segment4 hr_soft_coding_keyflex.segment4%type;
422: l_segment5 hr_soft_coding_keyflex.segment5%type;
423: l_segment11 hr_soft_coding_keyflex.segment11%type;
424: l_segment12 hr_soft_coding_keyflex.segment12%type;
425: l_segment13 hr_soft_coding_keyflex.segment13%type;
426: l_segment14 hr_soft_coding_keyflex.segment14%type;
427: l_segment15 hr_soft_coding_keyflex.segment15%type;
428: l_segment16 hr_soft_coding_keyflex.segment16%type;

Line 425: l_segment13 hr_soft_coding_keyflex.segment13%type;

421: l_segment4 hr_soft_coding_keyflex.segment4%type;
422: l_segment5 hr_soft_coding_keyflex.segment5%type;
423: l_segment11 hr_soft_coding_keyflex.segment11%type;
424: l_segment12 hr_soft_coding_keyflex.segment12%type;
425: l_segment13 hr_soft_coding_keyflex.segment13%type;
426: l_segment14 hr_soft_coding_keyflex.segment14%type;
427: l_segment15 hr_soft_coding_keyflex.segment15%type;
428: l_segment16 hr_soft_coding_keyflex.segment16%type;
429: l_notice_concat varchar2(180);

Line 426: l_segment14 hr_soft_coding_keyflex.segment14%type;

422: l_segment5 hr_soft_coding_keyflex.segment5%type;
423: l_segment11 hr_soft_coding_keyflex.segment11%type;
424: l_segment12 hr_soft_coding_keyflex.segment12%type;
425: l_segment13 hr_soft_coding_keyflex.segment13%type;
426: l_segment14 hr_soft_coding_keyflex.segment14%type;
427: l_segment15 hr_soft_coding_keyflex.segment15%type;
428: l_segment16 hr_soft_coding_keyflex.segment16%type;
429: l_notice_concat varchar2(180);
430: l_notice_period per_all_assignments_f.notice_period%type;

Line 427: l_segment15 hr_soft_coding_keyflex.segment15%type;

423: l_segment11 hr_soft_coding_keyflex.segment11%type;
424: l_segment12 hr_soft_coding_keyflex.segment12%type;
425: l_segment13 hr_soft_coding_keyflex.segment13%type;
426: l_segment14 hr_soft_coding_keyflex.segment14%type;
427: l_segment15 hr_soft_coding_keyflex.segment15%type;
428: l_segment16 hr_soft_coding_keyflex.segment16%type;
429: l_notice_concat varchar2(180);
430: l_notice_period per_all_assignments_f.notice_period%type;
431: l_notice_uom per_all_assignments_f.notice_period_uom%type;

Line 428: l_segment16 hr_soft_coding_keyflex.segment16%type;

424: l_segment12 hr_soft_coding_keyflex.segment12%type;
425: l_segment13 hr_soft_coding_keyflex.segment13%type;
426: l_segment14 hr_soft_coding_keyflex.segment14%type;
427: l_segment15 hr_soft_coding_keyflex.segment15%type;
428: l_segment16 hr_soft_coding_keyflex.segment16%type;
429: l_notice_concat varchar2(180);
430: l_notice_period per_all_assignments_f.notice_period%type;
431: l_notice_uom per_all_assignments_f.notice_period_uom%type;
432: begin

Line 993: from hr_soft_coding_keyflex keyflx,per_all_assignments_f paaf

989: ,P_EMPLOYMENT_CATEGORY in VARCHAR2) is
990:
991: cursor csr_get_contract_cat is
992: select segment3
993: from hr_soft_coding_keyflex keyflx,per_all_assignments_f paaf
994: where paaf.soft_coding_keyflex_id=keyflx.soft_coding_keyflex_id --Changed the join condition for Bug 7425845
995: and paaf.effective_start_date between effective_start_date and effective_end_date
996: and assignment_id=p_assignment_id;
997:

Line 1005: l_contract_category hr_soft_coding_keyflex.segment3%type;

1001: from per_all_assignments_f
1002: where assignment_id=P_ASSIGNMENT_ID
1003: and P_EFFECTIVE_DATE between effective_start_date and effective_end_date;
1004:
1005: l_contract_category hr_soft_coding_keyflex.segment3%type;
1006: l_join_variable number(10);
1007: l_assgt_type per_assignment_status_types.per_system_status%type;
1008: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;
1009: l_tax_office per_all_people_f.per_information6%TYPE;

Line 1203: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf

1199: where assignment_id = p_assignment_id;
1200:
1201: cursor csr_segment3 is
1202: select soft.segment3
1203: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf
1204: where paaf.soft_coding_keyflex_id = soft.soft_coding_keyflex_id
1205: and paaf.assignment_id = p_assignment_id
1206: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1207:

Line 1215: l_segment3 hr_soft_coding_keyflex.segment3%TYPE;

1211: l_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
1212: l_effective_date_warning boolean;
1213: l_record_exists varchar2(1);
1214: l_business_group_id pay_pl_paye_details_f.business_group_id%TYPE;
1215: l_segment3 hr_soft_coding_keyflex.segment3%TYPE;
1216: l_proc varchar2(19);
1217: cursor csr_paye_exists is
1218: select '1'
1219: from pay_pl_paye_details_f