APPS.PER_MX_SS_AFFILIATION dependencies on PER_ASSIGNMENTS_F

Line 396: FROM per_assignments_f

392:
393: -- Bug 6008833
394: p_sqlstr :=
395: 'SELECT DISTINCT person_id
396: FROM per_assignments_f
397: WHERE business_group_id = '||g_business_group||'
398: /*AND fnd_date.canonical_to_date('''||l_new_end_date
399: ||''') BETWEEN effective_start_date AND effective_end_date*/
400: AND per_mx_ss_affiliation.derive_gre_from_loc_scl (location_id,

Line 439: FROM per_assignments_f paf,

435: paf.assignment_id,
436: pai.action_context_id,
437: paf.primary_flag,
438: pai.tax_unit_id
439: FROM per_assignments_f paf,
440: pay_action_information pai
441: WHERE pai.action_information_category = 'MX SS TRANSACTIONS'
442: AND paf.business_group_id = g_business_group
443: AND paf.person_id BETWEEN p_start_person_id AND p_end_person_id

Line 492: FROM per_assignments_f paf,

488: paf.assignment_id,
489: pai.action_context_id,
490: paf.primary_flag,
491: pai.tax_unit_id
492: FROM per_assignments_f paf,
493: pay_action_information pai,
494: pay_population_ranges ppr
495: WHERE pai.action_information_category = 'MX SS TRANSACTIONS'
496: AND paf.business_group_id = g_business_group

Line 572: lv_primary_flag per_assignments_f.primary_flag%type;

568: ln_arch_asg_act number;
569: ln_asg_id number;
570: ln_affl_asg_act number;
571: ln_tax_unit_id number;
572: lv_primary_flag per_assignments_f.primary_flag%type;
573: ln_exist number;
574: l_report number;
575: ld_end_date date;
576: l_new_end_date varchar2(25);

Line 1061: FROM per_assignments_f paf,

1057:
1058:
1059: CURSOR csr_person (cp_assignment_action_id number) IS
1060: SELECT paf.person_id
1061: FROM per_assignments_f paf,
1062: pay_assignment_actions paa
1063: WHERE paa.assignment_action_id = cp_assignment_action_id
1064: AND paa.assignment_id = paf.assignment_id;
1065: