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 145: -------core store this in employment_category in per_all_assignments_f table..displays it as assignment_category on UI

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

Line 370: from per_all_assignments_f

366: )is
367:
368: cursor csr_get_payroll_emp_cat is
369: select payroll_id,employment_category
370: from per_all_assignments_f
371: where assignment_id=P_ASSIGNMENT_ID
372: and P_EFFECTIVE_DATE between effective_start_date and effective_end_date;
373:
374: cursor csr_get_contract_details(r_date date) is

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 384: from per_all_assignments_f

380:
381: -- Bug 7041296
382: cursor csr_effective_start_date is
383: select min(effective_start_date)
384: from per_all_assignments_f
385: where assignment_id=P_ASSIGNMENT_ID;
386:
387: -- Added for Bug 7510498
388: -- Modified for Bug 7554037

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 400: FROM per_all_assignments_f

396:
397: -- Added for Bug 7554037
398: CURSOR csr_get_notice_details is
399: SELECT NOTICE_PERIOD, NOTICE_PERIOD_UOM
400: FROM per_all_assignments_f
401: WHERE assignment_id=P_ASSIGNMENT_ID
402: and P_EFFECTIVE_DATE between effective_start_date and effective_end_date;
403:
404: l_employment_category per_all_assignments_f.employment_category%type;

Line 404: l_employment_category per_all_assignments_f.employment_category%type;

400: FROM per_all_assignments_f
401: WHERE assignment_id=P_ASSIGNMENT_ID
402: and P_EFFECTIVE_DATE between effective_start_date and effective_end_date;
403:
404: l_employment_category per_all_assignments_f.employment_category%type;
405: l_proc varchar2(35);
406: l_assgt_type varchar2(30);
407: l_prev_assgt_type varchar2(30);
408: l_oldage_pension_rights per_all_people_f.per_information4%TYPE;

Line 430: l_notice_period per_all_assignments_f.notice_period%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
433: --1)Mandatory argument checks
434: --2)Conditionally mandatory arguments ...planned valid to date,notice_period,notice_period_date(scl_segment15),notice_period_end_date(scl_segment16)

Line 431: l_notice_uom per_all_assignments_f.notice_period_uom%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
433: --1)Mandatory argument checks
434: --2)Conditionally mandatory arguments ...planned valid to date,notice_period,notice_period_date(scl_segment15),notice_period_end_date(scl_segment16)
435: --3)you cannot correct or update segment3 once enetred

Line 768: from per_all_assignments_f

764: l_business_group_id number(10);
765:
766: cursor csr_get_person_bus_id is
767: select person_id,business_group_id
768: from per_all_assignments_f
769: where assignment_id=p_assignment_id
770: and p_effective_date between effective_start_date and effective_end_date;
771:
772: cursor csr_sii_already_exists is

Line 849: from per_all_assignments_f

845:
846:
847: cursor csr_get_person_bus_id is
848: select person_id,business_group_id
849: from per_all_assignments_f
850: where assignment_id=p_assignment_id
851: and p_effective_date between effective_start_date and effective_end_date;
852:
853: cursor csr_paye_already_exists is

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 1001: from per_all_assignments_f

997:
998: --Added for bug 7554037
999: cursor csr_get_payroll_emp_cat is
1000: select employment_category
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;

Line 1010: l_employment_category per_all_assignments_f.employment_category%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;
1010: l_employment_category per_all_assignments_f.employment_category%TYPE;
1011: l_one number(1);
1012: l_person_id number(10);
1013: l_proc varchar2(44);
1014:

Line 1144: from per_all_assignments_f

1140: P_SCL_SEGMENT3 in varchar2) is
1141:
1142: cursor csr_business_group is
1143: select business_group_id
1144: from per_all_assignments_f
1145: where assignment_id = p_assignment_id;
1146:
1147: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1148:

Line 1147: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

1143: select business_group_id
1144: from per_all_assignments_f
1145: where assignment_id = p_assignment_id;
1146:
1147: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1148:
1149: l_object_version_number pay_pl_paye_details_f.object_version_number%type;
1150: l_paye_details_id pay_pl_paye_details_f.paye_details_id%type;
1151: l_effective_start_date pay_pl_paye_details_f.effective_start_date%type;

Line 1198: from per_all_assignments_f

1194:
1195:
1196: cursor csr_business_group is
1197: select business_group_id
1198: from per_all_assignments_f
1199: where assignment_id = p_assignment_id;
1200:
1201: cursor csr_segment3 is
1202: select soft.segment3

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: