APPS.PAY_YEAR_END_EXTRACT dependencies on PER_PEOPLE_F

Line 53: Added TITLE to extract from per_people_f

49: Defaulted Taxcode from element if no run exists
50: Speeded up latest PAYE action fetch
51: aparkes 11-Jul-1997 Added updates to ye_assignments for employee
52: Address,Start_of_emp.
53: Added TITLE to extract from per_people_f
54: Used cursor for SCON NIF, G and S balances.
55: amills 16-Jan-1998 Bug 572938. Added a new update statement
56: 'Retrieve element entry update recurring'
57: for update of pay_gb_year_end_assignments

Line 1115: from per_people_f per

1111: substr(NATIONAL_IDENTIFIER,1,9) NATIONAL_IDENTIFIER,
1112: substr(SEX,1,1) SEX ,
1113: decode(substr(PER_INFORMATION4,1,1),'Y','P',' ') PENSIONER_INDICATOR,
1114: decode(PER_INFORMATION9,'Y','Y',null) MULTIPLE_ASG_FLAG -- MII
1115: from per_people_f per
1116: where per.person_id = ye_asg.person_id
1117: and ye_asg.request_id = p_request_id
1118: and l_end_year between
1119: per.effective_start_date and per.effective_end_date )

Line 1128: per_people_f per

1124: hr_utility.set_location('PAY_YEAR_END_EXTRACT.EXTRACT',22);
1125: hr_utility.trace( 'set director indicator ' );
1126: update pay_gb_year_end_assignments ye_asg set ( DIRECTOR_INDICATOR ) =
1127: ( select 'D' from dual where exists ( select '1' from
1128: per_people_f per
1129: where ye_asg.person_id = per.person_id
1130: and per.effective_start_date <= l_end_year
1131: and per.effective_end_date >= l_start_year
1132: and substr(PER_INFORMATION2,1,1) = 'Y'))