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_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 494: p_reason_code in per_periods_of_service.leaving_reason%type

490: function get_termination_reason
491: (
492: p_business_group_id in per_all_assignments_f.business_group_id%type,
493: p_report_date in per_all_assignments_f.effective_end_date%type,
494: p_reason_code in per_periods_of_service.leaving_reason%type
495: ) return varchar2 is
496:
497: l_termination_reason pay_user_column_instances_f.value%type;
498:

Line 1207: l_date_start per_periods_of_service.date_start%type;

1203: p_period_of_service_id in per_all_assignments_f.period_of_service_id%type
1204: ) return varchar2 is
1205:
1206: l_ee_employment_type_name varchar2(13);
1207: l_date_start per_periods_of_service.date_start%type;
1208: l_date_end date;
1209: l_actual_termination_date per_periods_of_service.actual_termination_date%type;
1210: l_projected_termination_date per_periods_of_service.projected_termination_date%type;
1211:

Line 1209: l_actual_termination_date per_periods_of_service.actual_termination_date%type;

1205:
1206: l_ee_employment_type_name varchar2(13);
1207: l_date_start per_periods_of_service.date_start%type;
1208: l_date_end date;
1209: l_actual_termination_date per_periods_of_service.actual_termination_date%type;
1210: l_projected_termination_date per_periods_of_service.projected_termination_date%type;
1211:
1212: begin
1213:

Line 1210: l_projected_termination_date per_periods_of_service.projected_termination_date%type;

1206: l_ee_employment_type_name varchar2(13);
1207: l_date_start per_periods_of_service.date_start%type;
1208: l_date_end date;
1209: l_actual_termination_date per_periods_of_service.actual_termination_date%type;
1210: l_projected_termination_date per_periods_of_service.projected_termination_date%type;
1211:
1212: begin
1213:
1214: select date_start,

Line 1220: from per_periods_of_service

1216: projected_termination_date
1217: into l_date_start,
1218: l_actual_termination_date,
1219: l_projected_termination_date
1220: from per_periods_of_service
1221: where period_of_service_id = p_period_of_service_id;
1222:
1223: if l_actual_termination_date is null then
1224:

Line 2830: per_periods_of_service ppos,

2826: hr_lookups hl2,
2827: hr_all_organization_units haou,
2828: per_assignment_extra_info paei,
2829: per_all_assignments_f paaf,
2830: per_periods_of_service ppos,
2831: per_all_people_f papf
2832: where papf.business_group_id = p_business_group_id
2833: and papf.current_employee_flag = 'Y'
2834: and ppos.person_id = papf.person_id

Line 3060: per_periods_of_service ppos,

3056: hr_lookups hl2,
3057: hr_all_organization_units haou,
3058: per_assignment_extra_info paei,
3059: per_all_assignments_f paaf,
3060: per_periods_of_service ppos,
3061: per_all_people_f papf
3062: where papf.business_group_id = p_business_group_id
3063: and papf.current_employee_flag = 'Y'
3064: and ppos.person_id = papf.person_id

Line 3315: per_periods_of_service ppos,

3311: hr_lookups hl2,
3312: hr_all_organization_units haou,
3313: per_assignment_extra_info paei,
3314: per_all_assignments_f paaf,
3315: per_periods_of_service ppos,
3316: per_all_people_f papf
3317: where papf.business_group_id = p_business_group_id
3318: and papf.current_employee_flag = 'Y'
3319: and ppos.person_id = papf.person_id

Line 3581: per_periods_of_service ppos,

3577: hr_lookups hl2,
3578: hr_all_organization_units haou,
3579: per_assignment_extra_info paei,
3580: per_all_assignments_f paaf,
3581: per_periods_of_service ppos,
3582: per_all_people_f papf
3583: where papf.business_group_id = p_business_group_id
3584: and papf.current_employee_flag = 'Y'
3585: and ppos.person_id = papf.person_id

Line 7323: p_reason_code in per_periods_of_service.leaving_reason%type

7319: function get_termination_reason_new
7320: (
7321: p_business_group_id in per_all_assignments_f.business_group_id%type,
7322: p_report_date in per_all_assignments_f.effective_end_date%type,
7323: p_reason_code in per_periods_of_service.leaving_reason%type
7324: ) return varchar2 is
7325:
7326: l_termination_reason pay_user_column_instances_f.value%type;
7327:

Line 8417: per_periods_of_service ppos,

8413: -- hr_lookups hl2,
8414: hr_all_organization_units haou,
8415: per_assignment_extra_info paei,
8416: per_all_assignments_f paaf,
8417: per_periods_of_service ppos,
8418: per_all_people_f papf
8419: where papf.business_group_id = p_business_group_id
8420: and papf.current_employee_flag = 'Y'
8421: and ppos.person_id = papf.person_id

Line 8647: per_periods_of_service ppos,

8643: -- hr_lookups hl2,
8644: hr_all_organization_units haou,
8645: per_assignment_extra_info paei,
8646: per_all_assignments_f paaf,
8647: per_periods_of_service ppos,
8648: per_all_people_f papf
8649: where papf.business_group_id = p_business_group_id
8650: and papf.current_employee_flag = 'Y'
8651: and ppos.person_id = papf.person_id

Line 8902: per_periods_of_service ppos,

8898: -- hr_lookups hl2,
8899: hr_all_organization_units haou,
8900: per_assignment_extra_info paei,
8901: per_all_assignments_f paaf,
8902: per_periods_of_service ppos,
8903: per_all_people_f papf
8904: where papf.business_group_id = p_business_group_id
8905: and papf.current_employee_flag = 'Y'
8906: and ppos.person_id = papf.person_id

Line 9171: per_periods_of_service ppos,

9167: -- hr_lookups hl2,
9168: hr_all_organization_units haou,
9169: per_assignment_extra_info paei,
9170: per_all_assignments_f paaf,
9171: per_periods_of_service ppos,
9172: per_all_people_f papf
9173: where papf.business_group_id = p_business_group_id
9174: and papf.current_employee_flag = 'Y'
9175: and ppos.person_id = papf.person_id