APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PER_PERIODS_OF_SERVICE

Line 147: Now joining to per_periods_of_service

143: 02-Sep-2003 meshah 115.29 3124483 using actual_termination_date instead
144: of final_prcess_date.
145: 02-Sep-2003 meshah 115.28 3124483 the cursor get_person_info in
146: get_doc_eit function has been changed.
147: Now joining to per_periods_of_service
148: to find out if the employee is
149: terminated.
150: 19-JUL-2003 ahanda 115.27 Added function format_to_date.
151: 23-May-03 ekim 115.26 2897743 Added c_get_lookup_for_paid.

Line 1871: /* adding a join to per_periods_of_service. If the employee is terminated then

1867: where hoi.organization_id = l_business_group_id
1868: and hoi.org_information_context = 'HR_SELF_SERVICE_BG_PREFERENCE'
1869: and hoi.org_information1 = upper(p_doc_type) ;
1870:
1871: /* adding a join to per_periods_of_service. If the employee is terminated then
1872: the person does not have access to online doc, so we should always return a
1873: N.
1874:
1875: -- RLN Bug 9074420 added or condition for bug 10628755 11730301 --*/

Line 1879: from per_assignments_f paf, per_periods_of_service pps

1875: -- RLN Bug 9074420 added or condition for bug 10628755 11730301 --*/
1876: CURSOR get_person_info(l_assignment_id number) IS
1877: select paf.business_group_id, paf.organization_id,
1878: paf.location_id, paf.person_id
1879: from per_assignments_f paf, per_periods_of_service pps
1880: where paf.assignment_id = l_assignment_id
1881: and p_effective_date between paf.effective_start_date
1882: and paf.effective_end_date
1883: and pps.period_of_service_id = paf.period_of_service_id

Line 1890: from per_assignments_f paf, per_periods_of_service pps

1886: /* --TERM cursor RLN 11730301 -- */
1887: CURSOR get_person_info_t(l_assignment_id number) IS
1888: select paf.business_group_id, paf.organization_id,
1889: paf.location_id, paf.person_id
1890: from per_assignments_f paf, per_periods_of_service pps
1891: where paf.assignment_id = l_assignment_id --13084713 Removed eff. date from where clause
1892: and pps.period_of_service_id = paf.period_of_service_id
1893: and pps.actual_termination_date between paf.effective_start_date
1894: and paf.effective_end_date;

Line 1931: from per_periods_of_service pps,

1927: /* --RLN Check actual_termination_date 11730301 --- */
1928: /*--13084713 Added Max for the termination date and Removed eff. date from where clause */
1929: Select nvl(max(pps.actual_termination_date), to_date('12/31/4712','mm/dd/yyyy'))
1930: into l_actual_termination_date
1931: from per_periods_of_service pps,
1932: per_assignments_f paf
1933: where paf.assignment_id = p_id
1934: and pps.period_of_service_id = paf.period_of_service_id;
1935:

Line 2337: from per_periods_of_service pps,

2333: --get_legislation_code(p_business_group_id);
2334:
2335: cursor c_get_terminate_date is
2336: select actual_termination_date, pai.action_information16
2337: from per_periods_of_service pps,
2338: pay_action_information pai
2339: where pps.person_id = p_person_id
2340: and pai.action_context_id = p_action_context_id
2341: and pai.action_information_category = 'EMPLOYEE DETAILS'

Line 2350: from per_periods_of_service pps

2346: cursor c_get_term_details(p_actual_termination_date varchar2,
2347: p_time_period_id number) is
2348: /* Changed this for bug 4132132
2349: select 'Y'
2350: from per_periods_of_service pps
2351: where person_id = p_person_id
2352: and decode(actual_termination_date,NULL,date_start,p_effective_start_date)
2353: between date_start
2354: and nvl(actual_termination_date,p_effective_end_date) ;