[Home] [Help]
223: papf.sex,
224: papf.nationality,
225: paaf.work_at_home
226: FROM per_people_f papf,
227: per_assignments_f paaf
228: WHERE paaf.person_id = papf.person_id
229: AND paaf.assignment_id = cp_assignment_id
230: AND p_xfr_effective_date BETWEEN papf.effective_start_date
231: AND papf.effective_end_date
759: ORDER BY 1;
760:
761: CURSOR c_business_grp_id IS
762: SELECT DISTINCT business_group_id
763: FROM per_assignments_f
764: WHERE assignment_id = p_assignment_id;
765:
766:
767: ln_primary_balance_id NUMBER;
1494: WHERE paa.assignment_action_id = cp_asg_act_id;
1495:
1496: CURSOR c_business_grp_id IS
1497: SELECT DISTINCT business_group_id
1498: FROM per_assignments_f
1499: WHERE assignment_id = p_assignment_id;
1500:
1501: ln_element_type_id NUMBER;
1502: lv_reporting_name pay_element_types_f.reporting_name%TYPE;
1761: ,pay_input_values_f piv
1762: ,pay_element_types_f pet
1763: ,pay_element_types_f_tl petl
1764: ,pay_element_classifications pec
1765: ,per_assignments_f paf
1766: WHERE ppa.action_type IN ('R','Q','B','V')
1767: AND ppa.action_status = 'C'
1768: AND ppa.payroll_action_id = paa.payroll_action_id
1769: AND paa.assignment_action_id = prr.assignment_action_id
1848: ,pay_element_types_f pet
1849: ,pay_element_types_f_tl petl
1850: ,pay_element_classifications pec
1851: ,pay_action_interlocks pai
1852: ,per_assignments_f paf
1853: WHERE ppa.action_type IN ('R','Q','B','V')
1854: AND ppa.action_status = 'C'
1855: AND ppa.payroll_action_id = paa.payroll_action_id
1856: AND paa.assignment_action_id = prr.assignment_action_id
2050: lv_run_bal_status VARCHAR2(1);
2051:
2052: CURSOR c_business_grp_id IS
2053: SELECT DISTINCT business_group_id
2054: FROM per_assignments_f
2055: WHERE assignment_id = p_assignment_id;
2056:
2057: CURSOR c_get_elements_processed(cp_assignment_id IN NUMBER
2058: ,cp_curr_eff_date IN DATE
2300: lv_sql_string :=
2301: 'SELECT DISTINCT paf.person_id
2302: FROM pay_assignment_actions paa,
2303: pay_payroll_actions ppa,
2304: per_assignments_f paf
2305: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2306: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2307: fnd_date.date_to_canonical(ld_start_date) || ''')
2308: AND fnd_date.canonical_to_date(''' ||
2370: paa.assignment_action_id,
2371: paa.payroll_action_id
2372: FROM pay_payroll_actions ppa,
2373: pay_assignment_actions paa,
2374: per_assignments_f paf
2375: WHERE paf.person_id BETWEEN cp_start_person_id
2376: AND cp_end_person_id
2377: AND paa.assignment_id = paf.assignment_id
2378: AND ppa.effective_date BETWEEN paf.effective_start_date
2419: paa.assignment_action_id,
2420: paa.payroll_action_id
2421: FROM pay_payroll_actions ppa,
2422: pay_assignment_actions paa,
2423: per_assignments_f paf,
2424: pay_population_ranges ppr
2425: WHERE ppr.payroll_action_id = cp_payroll_action_id
2426: AND ppr.chunk_number = cp_chunk_number
2427: AND paf.person_id = ppr.person_id
3073: ,cp_effective_date IN DATE
3074: ) IS
3075: SELECT DISTINCT paf.organization_id,
3076: paf.business_group_id
3077: FROM per_assignments_f paf
3078: WHERE paf.payroll_id = cp_payroll_id
3079: AND cp_effective_date BETWEEN paf.effective_start_date
3080: AND paf.effective_end_date;
3081: