[Home] [Help]
621: ORDER BY 1;
622:
623: CURSOR c_business_grp_id IS
624: SELECT DISTINCT business_group_id
625: FROM per_assignments_f
626: WHERE assignment_id = p_assignment_id;
627:
628:
629: ln_primary_balance_id NUMBER;
964: AND balance_name = cp_balance_name;
965:
966: CURSOR c_last_per_xfr_run IS
967: SELECT pai.action_context_id
968: FROM per_assignments_f paf2,
969: per_assignments_f paf,
970: pay_action_information pai
971: WHERE paf.assignment_id = p_assignment_id
972: AND paf.effective_end_date >= trunc(p_pymt_eff_date, 'Y')
965:
966: CURSOR c_last_per_xfr_run IS
967: SELECT pai.action_context_id
968: FROM per_assignments_f paf2,
969: per_assignments_f paf,
970: pay_action_information pai
971: WHERE paf.assignment_id = p_assignment_id
972: AND paf.effective_end_date >= trunc(p_pymt_eff_date, 'Y')
973: AND paf.effective_start_date <= p_pymt_eff_date
1566: WHERE paa.assignment_action_id = cp_asg_act_id;
1567:
1568: CURSOR c_business_grp_id IS
1569: SELECT DISTINCT business_group_id
1570: FROM per_assignments_f
1571: WHERE assignment_id = p_assignment_id;
1572:
1573: ln_element_type_id NUMBER;
1574: lv_element_classification_name VARCHAR2(80);
1853: lv_run_bal_status VARCHAR2(1);
1854:
1855: CURSOR c_business_grp_id IS
1856: SELECT DISTINCT business_group_id
1857: FROM per_assignments_f
1858: WHERE assignment_id = p_assignment_id;
1859:
1860: CURSOR c_prev_ytd_action_elem_rbr(cp_assignment_id IN NUMBER
1861: ,cp_curr_eff_date IN DATE
2239: lv_sql_string :=
2240: 'SELECT DISTINCT paf.person_id
2241: FROM pay_assignment_actions paa,
2242: pay_payroll_actions ppa,
2243: per_assignments_f paf
2244: WHERE ppa.business_group_id = ''' || ln_business_group_id || '''
2245: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
2246: fnd_date.date_to_canonical(ld_start_date) || ''')
2247: AND fnd_date.canonical_to_date(''' ||
2309: paa.assignment_action_id,
2310: paa.payroll_action_id
2311: FROM pay_payroll_actions ppa,
2312: pay_assignment_actions paa,
2313: per_assignments_f paf
2314: WHERE paf.person_id BETWEEN cp_start_person_id
2315: AND cp_end_person_id
2316: AND paa.assignment_id = paf.assignment_id
2317: AND ppa.effective_date BETWEEN paf.effective_start_date
2358: paa.assignment_action_id,
2359: paa.payroll_action_id
2360: FROM pay_payroll_actions ppa,
2361: pay_assignment_actions paa,
2362: per_assignments_f paf,
2363: pay_population_ranges ppr
2364: WHERE ppr.payroll_action_id = cp_payroll_action_id
2365: AND ppr.chunk_number = cp_chunk_number
2366: AND paf.person_id = ppr.person_id
3094: || DECODE(middle_names,NULL, '', ' ' || middle_names)
3095: ))
3096: FROM per_people_f ppf
3097: WHERE ppf.person_id =
3098: (SELECT person_id FROM per_assignments_f paf
3099: WHERE assignment_id = cp_assignment_id
3100: AND cp_effective_date BETWEEN paf.effective_start_date
3101: AND paf.effective_end_date)
3102: AND cp_effective_date BETWEEN ppf.effective_start_date
3220: , cp_curr_eff_date IN DATE
3221: ) IS
3222: SELECT ppf.per_information2 rfc_id,
3223: ppf.per_information3 ss_id
3224: FROM per_assignments_f paf,
3225: per_people_f ppf
3226: WHERE paf.person_id = ppf.person_id
3227: AND paf.assignment_id = cp_assignment_id
3228: AND cp_curr_eff_date BETWEEN paf.effective_start_date
3871:
3872: CURSOR c_get_organization(cp_payroll_id IN NUMBER
3873: ,cp_effective_date IN DATE
3874: ) IS
3875: SELECT /*+ INDEX(paf PER_ASSIGNMENTS_F_N7)*/
3876: DISTINCT paf.organization_id,
3877: paf.business_group_id
3878: FROM per_all_assignments_f paf
3879: WHERE paf.payroll_id = cp_payroll_id
4333: lv_attribute_name VARCHAR2(80);
4334:
4335: CURSOR c_business_grp_id IS
4336: SELECT DISTINCT business_group_id
4337: FROM per_assignments_f
4338: WHERE assignment_id = p_assignment_id;
4339:
4340: CURSOR c_prev_ytd_action_elem_rbr(cp_assignment_id IN NUMBER
4341: ,cp_curr_eff_date IN DATE