APPS.PAY_AC_ACTION_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 641: from per_all_assignments_f paf2

637: ,cp_xfr_action_id in number
638: ,cp_effective_date in date) is
639: select pai.effective_date,
640: pai.action_context_id
641: from per_all_assignments_f paf2
642: ,per_all_assignments_f paf
643: ,pay_action_information pai
644: where paf2.assignment_id = cp_assignment_id
645: and paf.person_id = paf2.person_id

Line 642: ,per_all_assignments_f paf

638: ,cp_effective_date in date) is
639: select pai.effective_date,
640: pai.action_context_id
641: from per_all_assignments_f paf2
642: ,per_all_assignments_f paf
643: ,pay_action_information pai
644: where paf2.assignment_id = cp_assignment_id
645: and paf.person_id = paf2.person_id
646: and pai.assignment_id = paf.assignment_id

Line 2328: FROM per_all_assignments_f peaf,

2324: || '-'
2325: || puc.county_code
2326: || '-'
2327: || punc.city_code jurisdiction_code
2328: FROM per_all_assignments_f peaf,
2329: hr_locations_all hla,
2330: pay_us_states pus,
2331: pay_us_counties puc,
2332: pay_us_city_names punc,

Line 3197: from per_all_assignments_f

3193: lv_rb_status VARCHAR2(1);
3194:
3195: cursor c_business_grp_id is
3196: select distinct business_group_id
3197: from per_all_assignments_f
3198: where assignment_id = p_assignment_id;
3199:
3200: BEGIN
3201:

Line 4521: FROM per_all_assignments_f peaf,

4517: || '-'
4518: || puc.county_code
4519: || '-'
4520: || punc.city_code jurisdiction_code
4521: FROM per_all_assignments_f peaf,
4522: hr_locations_all hla,
4523: pay_us_states pus,
4524: pay_us_counties puc,
4525: pay_us_city_names punc,

Line 5056: FROM per_all_assignments_f peaf,

5052: || '-'
5053: || puc.county_code
5054: || '-'
5055: || punc.city_code jurisdiction_code
5056: FROM per_all_assignments_f peaf,
5057: hr_locations_all hla,
5058: pay_us_states pus,
5059: pay_us_counties puc,
5060: pay_us_city_names punc,