APPS.PER_MX_SS_AFFILIATION dependencies on PER_ASSIGNMENTS_F

Line 367: FROM per_assignments_f

363:
364: -- Bug 6008833
365: p_sqlstr :=
366: 'SELECT DISTINCT person_id
367: FROM per_assignments_f
368: WHERE business_group_id = '||g_business_group||'
369: /*AND fnd_date.canonical_to_date('''||g_end_date
370: ||''') BETWEEN effective_start_date AND effective_end_date*/
371: AND per_mx_ss_affiliation.derive_gre_from_loc_scl (location_id,

Line 408: FROM per_assignments_f paf,

404: paf.assignment_id,
405: pai.action_context_id,
406: paf.primary_flag,
407: pai.tax_unit_id
408: FROM per_assignments_f paf,
409: pay_action_information pai
410: WHERE pai.action_information_category = 'MX SS TRANSACTIONS'
411: AND paf.business_group_id = g_business_group
412: AND paf.person_id BETWEEN p_start_person_id AND p_end_person_id

Line 457: FROM per_assignments_f paf,

453: paf.assignment_id,
454: pai.action_context_id,
455: paf.primary_flag,
456: pai.tax_unit_id
457: FROM per_assignments_f paf,
458: pay_action_information pai,
459: pay_population_ranges ppr
460: WHERE pai.action_information_category = 'MX SS TRANSACTIONS'
461: AND paf.business_group_id = g_business_group

Line 512: lv_primary_flag per_assignments_f.primary_flag%type;

508: ln_arch_asg_act number;
509: ln_asg_id number;
510: ln_affl_asg_act number;
511: ln_tax_unit_id number;
512: lv_primary_flag per_assignments_f.primary_flag%type;
513:
514: BEGIN
515: l_proc_name := g_proc_name || 'ACTION_CREATION';
516: hr_utility_trace ('Entering '||l_proc_name);

Line 911: FROM per_assignments_f paf,

907:
908:
909: CURSOR csr_person (cp_assignment_action_id number) IS
910: SELECT paf.person_id
911: FROM per_assignments_f paf,
912: pay_assignment_actions paa
913: WHERE paa.assignment_action_id = cp_assignment_action_id
914: AND paa.assignment_id = paf.assignment_id;
915: