APPS.PAY_P45_PKG dependencies on PER_ALL_PEOPLE_F

Line 860: from per_all_people_f p

856: --
857: cursor agg_paye(c_person_id in number,
858: c_effective_date in date) is
859: select decode(p.per_information10,'Y','Y',NULL) agg_paye_flag
860: from per_all_people_f p
861: where p.person_id = c_person_id
862: and c_effective_date between
863: p.effective_start_date and p.effective_end_date;
864: --

Line 886: FROM per_all_people_f

882: -- Cursor to find last date after assignment's termination date until which
883: -- aggregation flag has remained Y - assuming flag is Y at the termination date
884: CURSOR get_aggregation_end IS
885: SELECT nvl((min(effective_start_date)-1), hr_general.end_of_time) agg_end_date
886: FROM per_all_people_f
887: WHERE person_id = X_PERSON_ID
888: AND effective_start_date > X_ASSIGNMENT_END_DATE
889: AND nvl(per_information10, 'N') = 'N';
890: --

Line 1317: from per_all_people_f p

1313: , a.assignment_number
1314: , a.payroll_id
1315: , org.organization_id
1316: , org.name org_name
1317: from per_all_people_f p
1318: , per_all_assignments_f a
1319: , per_periods_of_service serv
1320: , hr_all_organization_units org
1321: , fnd_sessions sess

Line 2159: FROM per_all_people_f p,

2155: p.person_id,
2156: decode(p.per_information10,'Y','Y',NULL) agg_paye_flag,
2157: max(a.effective_end_date) asg_end_date,
2158: ptp.regular_payment_date
2159: FROM per_all_people_f p,
2160: per_all_assignments_f a,
2161: per_assignment_status_types past,
2162: pay_all_payrolls_f ppf,
2163: per_time_periods ptp,

Line 2214: per_all_people_f p,

2210: decode(p.per_information10,'Y','Y',NULL) agg_paye_flag,
2211: max(a.effective_end_date) asg_end_date,
2212: ptp.regular_payment_date
2213: FROM pay_population_ranges ppr,
2214: per_all_people_f p,
2215: per_all_assignments_f a,
2216: per_assignment_status_types past,
2217: pay_all_payrolls_f ppf,
2218: per_time_periods ptp,

Line 2261: FROM per_all_people_f

2257: -- Cursor to find last date after assignment's termination date until which
2258: -- aggregation flag has remained Y - assuming flag is Y at the termination date
2259: CURSOR get_agg_end(p_person_id NUMBER, p_term_date DATE) IS
2260: SELECT nvl((min(effective_start_date)-1), hr_general.end_of_time) agg_end_date
2261: FROM per_all_people_f
2262: WHERE person_id = p_person_id
2263: AND effective_start_date > p_term_date
2264: AND nvl(per_information10, 'N') = 'N';
2265: --

Line 2268: FROM per_all_people_f

2264: AND nvl(per_information10, 'N') = 'N';
2265: --
2266: CURSOR get_agg_start(p_person_id NUMBER, p_term_date DATE) IS
2267: SELECT nvl((max(effective_end_date)+1), hr_general.start_of_time) agg_start_date
2268: FROM per_all_people_f
2269: WHERE person_id = p_person_id
2270: AND effective_end_date < p_term_date
2271: AND nvl(per_information10, 'N') = 'N';
2272: --

Line 2856: per_all_people_f p,

2852: p.national_identifier, ass.payroll_id,
2853: decode(p.per_information10,'Y','Y',NULL) agg_paye_flag,
2854: p.date_of_birth, p.sex
2855: FROM
2856: per_all_people_f p,
2857: hr_all_organization_units org,
2858: per_periods_of_service serv,
2859: per_all_assignments_f ass
2860: WHERE ass.assignment_id = p_assid

Line 4062: from per_all_people_f

4058:
4059: cursor csr_aggr_paye_flag (c_person_id number,
4060: c_effective_date date) is
4061: select per_information10
4062: from per_all_people_f
4063: where person_id = c_person_id
4064: and c_effective_date between
4065: effective_start_date and effective_end_date;
4066: --

Line 4082: from per_all_people_f

4078: -- to fetch the earliest aggregation start date from the final payment date.
4079: --
4080: cursor csr_latest_aggr_start_date(c_person_id number, c_effective_date date) is
4081: select max(effective_end_date) + 1
4082: from per_all_people_f
4083: where person_id = c_person_id
4084: and nvl(per_information10,'N') = 'N'
4085: and effective_end_date < c_effective_date;
4086:

Line 4121: l_agg_paye_flag per_all_people_f.per_information10%type;

4117: l_assignment_action_id NUMBER;
4118: l_issue_date DATE;
4119: l_locked_action_id NUMBER;
4120: l_effective_date DATE;
4121: l_agg_paye_flag per_all_people_f.per_information10%type;
4122: l_found BOOLEAN;
4123: l_dummy NUMBER;
4124:
4125: l_agg_paye_reference hr_soft_coding_keyflex.segment1%type;