[Home] [Help]
155:
156: CURSOR c_non_sep_check(cp_pymt_assignment_action_id IN NUMBER) IS
157: SELECT paa.assignment_action_id
158: FROM pay_action_interlocks pai,
159: pay_assignment_actions paa,
160: pay_payroll_actions ppa
161: WHERE pai.locking_action_id = cp_pymt_assignment_action_id
162: AND paa.assignment_action_id = pai.locked_action_id
163: AND paa.payroll_action_id = ppa.payroll_action_id
536: pay_balance_attributes pba,
537: pay_defined_balances pdb,
538: pay_run_balances prb,
539: pay_action_interlocks pai,
540: pay_assignment_actions paa_pre,
541: pay_payroll_actions ppa_pre,
542: pay_balance_types pbt_pri,
543: pay_balance_types pbt_sec,
544: pay_balance_types_tl pbtl
587: pay_defined_balances pdb,
588: pay_run_results prr,
589: pay_input_values_f piv,
590: pay_action_interlocks pai,
591: pay_assignment_actions paa_pre,
592: pay_payroll_actions ppa_pre,
593: pay_balance_types pbt_pri,
594: pay_balance_types pbt_sec,
595: pay_balance_types_tl pbtl
1372: pay_balance_types pbt_pri,
1373: pay_balance_types pbt_sec,
1374: pay_balance_types_tl pbtl,
1375: pay_run_balances prb,
1376: pay_assignment_actions paa,
1377: pay_payroll_actions ppa
1378: WHERE pbad.attribute_name IN ('Employee Earnings',
1379: 'Hourly Earnings',
1380: 'Deductions',
1423: pay_balance_types pbt_sec,
1424: pay_balance_types_tl pbtl,
1425: pay_run_results prr,
1426: pay_input_values_f piv,
1427: pay_assignment_actions paa,
1428: pay_payroll_actions ppa
1429: WHERE pbad.attribute_name IN ('Employee Earnings',
1430: 'Hourly Earnings',
1431: 'Deductions',
1474: pay_balance_types pbt_pri,
1475: pay_balance_types pbt_sec,
1476: pay_balance_types_tl pbtl,
1477: pay_run_balances prb,
1478: pay_assignment_actions paa,
1479: pay_action_interlocks pai,
1480: pay_payroll_actions ppa
1481: WHERE pbad.attribute_name IN ('Employee Earnings',
1482: 'Hourly Earnings',
1527: pay_balance_types pbt_sec,
1528: pay_balance_types_tl pbtl,
1529: pay_run_results prr,
1530: pay_input_values_f piv,
1531: pay_assignment_actions paa,
1532: pay_action_interlocks pai,
1533: pay_payroll_actions ppa
1534: WHERE pbad.attribute_name IN ('Employee Earnings',
1535: 'Hourly Earnings',
1561:
1562:
1563: CURSOR c_ytd_action_seq(cp_asg_act_id IN NUMBER) IS
1564: SELECT paa.action_sequence
1565: FROM pay_assignment_actions paa
1566: WHERE paa.assignment_action_id = cp_asg_act_id;
1567:
1568: CURSOR c_business_grp_id IS
1569: SELECT DISTINCT business_group_id
1919: pay_defined_balances pdb,
1920: pay_balance_types pbt_pri,
1921: pay_balance_types pbt_sec,
1922: pay_balance_types_tl pbtl,
1923: pay_assignment_actions paa,
1924: pay_payroll_actions ppa,
1925: pay_run_results prr,
1926: pay_input_values_f piv
1927: WHERE pbad.attribute_name IN ('Employee Earnings',
2237: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2238:
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(''' ||
2260: AND paf.effective_end_date
2261: AND NOT EXISTS
2262: (SELECT ''x''
2263: FROM pay_action_interlocks pai,
2264: pay_assignment_actions paa1,
2265: pay_payroll_actions ppa1
2266: WHERE pai.locked_action_id = paa.assignment_action_id
2267: AND paa1.assignment_action_id = pai.locking_action_id
2268: AND ppa1.payroll_action_id = paa1.payroll_action_id
2308: ppa.action_type,
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
2331: AND paa.source_action_id IS NULL
2332: AND NOT EXISTS
2333: (SELECT 'x'
2334: FROM pay_action_interlocks pai1,
2335: pay_assignment_actions paa1,
2336: pay_payroll_actions ppa1
2337: WHERE pai1.locked_action_id = paa.assignment_action_id
2338: AND paa1.assignment_action_id = pai1.locking_action_id
2339: AND ppa1.payroll_action_id = paa1.payroll_action_id
2357: ppa.action_type,
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
2382: AND paa.source_action_id IS NULL
2383: AND NOT EXISTS
2384: (SELECT 'x'
2385: FROM pay_action_interlocks pai1,
2386: pay_assignment_actions paa1,
2387: pay_payroll_actions ppa1
2388: WHERE pai1.locked_action_id = paa.assignment_action_id
2389: AND paa1.assignment_action_id = pai1.locking_action_id
2390: AND ppa1.payroll_action_id = paa1.payroll_action_id
2394:
2395: CURSOR c_master_action(cp_prepayment_action_id NUMBER) IS
2396: SELECT MAX(paa.assignment_action_id)
2397: FROM pay_payroll_actions ppa,
2398: pay_assignment_actions paa,
2399: pay_action_interlocks pai
2400: WHERE pai.locking_action_Id = cp_prepayment_action_id
2401: AND paa.assignment_action_id = pai.locked_action_id
2402: AND paa.source_action_id IS NULL
2527: ELSE
2528: hr_utility.set_location(gv_package || lv_procedure_name, 60);
2529: hr_utility.trace('Action_type = '||lv_action_type );
2530:
2531: SELECT pay_assignment_actions_s.NEXTVAL
2532: INTO ln_xfr_action_id
2533: FROM dual;
2534:
2535: -- insert into pay_assignment_actions.
2531: SELECT pay_assignment_actions_s.NEXTVAL
2532: INTO ln_xfr_action_id
2533: FROM dual;
2534:
2535: -- insert into pay_assignment_actions.
2536: hr_nonrun_asact.insact(ln_xfr_action_id,
2537: ln_assignment_id,
2538: p_payroll_action_id,
2539: p_chunk,
2561: ********************************************************/
2562: lv_serial_number := lv_action_type || 'N' ||
2563: ln_asg_action_id;
2564:
2565: UPdate pay_assignment_actions
2566: SET serial_number = lv_serial_number
2567: WHERE assignment_action_id = ln_xfr_action_id;
2568:
2569: hr_utility.set_location(gv_package || lv_procedure_name, 100);
3191: ** #5 p_curr_eff_date : Effective Date of the Archive Process
3192: ** #6 p_date_earned : This is the date_earned for the Run
3193: ** Process.
3194: ** #7 p_curr_pymt_eff_date : The effective date of prepayments.
3195: ** #8 p_tax_unit_id : tax_unit_id from pay_assignment_actions
3196: ** #9 p_time_period_id : Time Period Id of the Run.
3197: ** #10 p_ppp_source_action_id : This is the source_action_id of
3198: ** pay_pre_payments for the 'P','U' action.
3199: ** #11 p_ytd_balcall_aaid : This is the assignment action id to call
3546:
3547: CURSOR c_ytd_aaid(cp_prepayment_action_id IN NUMBER
3548: ,cp_assignment_id IN NUMBER) IS
3549: SELECT paa.assignment_action_id
3550: FROM pay_assignment_actions paa,
3551: pay_action_interlocks pai,
3552: pay_payroll_actions ppa
3553: WHERE pai.locking_action_id = cp_prepayment_action_id
3554: AND paa.assignment_action_id = pai.locked_action_id
3561: CURSOR c_time_period(cp_run_assignment_action IN NUMBER) IS
3562: SELECT ptp.time_period_id,
3563: ppa.date_earned,
3564: ppa.effective_date
3565: FROM pay_assignment_actions paa,
3566: pay_payroll_actions ppa,
3567: per_time_periods ptp
3568: WHERE paa.assignment_action_id = cp_run_assignment_action
3569: AND ppa.payroll_action_id = paa.payroll_action_id
3571: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date;
3572:
3573: CURSOR c_chk_act_type(cp_last_xfr_act_id NUMBER) IS
3574: SELECT SUBSTR(serial_number,1,1)
3575: FROM pay_assignment_actions paa
3576: WHERE paa.assignment_action_id = cp_last_xfr_act_id;
3577:
3578: lv_pre_xfr_act_type VARCHAR2(80);
3579:
3883: CURSOR c_get_legal_ER IS
3884: SELECT DISTINCT hr_mx_utility.get_legal_employer(paf.business_group_id,
3885: paa.tax_unit_id)
3886: FROM per_all_assignments_f paf,
3887: pay_assignment_actions paa
3888: WHERE paa.payroll_action_id = p_payroll_action_id
3889: AND paa.assignment_id = paf.assignment_id
3890: AND paf.payroll_id = p_payroll_id
3891: AND p_effective_date BETWEEN paf.effective_start_date
3892: AND paf.effective_end_date;
3893:
3894: CURSOR c_get_gre IS
3895: SELECT DISTINCT paa.tax_unit_id
3896: FROM pay_assignment_actions paa
3897: WHERE paa.payroll_action_id = p_payroll_action_id;
3898:
3899:
3900: PROCEDURE get_legal_er_details(p_legal_er_id NUMBER
4399: pay_defined_balances pdb,
4400: pay_balance_types pbt_pri,
4401: pay_balance_types pbt_sec,
4402: pay_balance_types_tl pbtl,
4403: pay_assignment_actions paa,
4404: pay_payroll_actions ppa,
4405: pay_run_results prr,
4406: pay_input_values_f piv
4407: WHERE pbad.attribute_name IN ('Employee Earnings',
4743: paa.assignment_id,
4744: paa.tax_unit_id,
4745: paa.serial_number,
4746: paa.chunk_number
4747: FROM pay_assignment_actions paa
4748: WHERE paa.assignment_action_id = cp_assignment_action;
4749:
4750: CURSOR c_legislation (cp_business_group IN NUMBER) IS
4751: SELECT org_information9
4755:
4756: CURSOR c_assignment_run (cp_prepayment_action_id IN NUMBER) IS
4757: SELECT DISTINCT paa.assignment_id
4758: FROM pay_action_interlocks pai,
4759: pay_assignment_actions paa,
4760: pay_payroll_actions ppa
4761: WHERE pai.locking_action_id = cp_prepayment_action_id
4762: AND paa.assignment_action_id = pai.locked_action_id
4763: AND ppa.payroll_action_id = paa.payroll_action_id
4773: cp_assignment_id IN NUMBER) IS
4774: SELECT paa.assignment_action_id, paa.payroll_action_id,
4775: ppa.action_type
4776: FROM pay_payroll_actions ppa,
4777: pay_assignment_actions paa,
4778: pay_action_interlocks pai
4779: WHERE pai.locking_action_id = cp_prepayment_action_id
4780: AND pai.locked_action_id = paa.assignment_action_id
4781: AND paa.assignment_id = cp_assignment_id
4785:
4786: CURSOR c_pymt_eff_date(cp_prepayment_action_id IN NUMBER) IS
4787: SELECT ppa.effective_date
4788: FROM pay_payroll_actions ppa,
4789: pay_assignment_actions paa
4790: WHERE ppa.payroll_action_id = paa.payroll_action_id
4791: AND paa.assignment_action_id = cp_prepayment_action_id;
4792:
4793: CURSOR c_check_pay_action( cp_payroll_action_id IN NUMBER) IS
4809: ,cp_assignment_id NUMBER
4810: ,cp_tax_unit_id NUMBER) IS
4811: SELECT paa.assignment_action_id
4812: ,paa.source_action_id
4813: FROM pay_assignment_actions paa
4814: ,pay_action_interlocks pai
4815: where pai.locking_action_id = cp_pp_asg_act_id
4816: AND paa.assignment_action_id = pai.locked_action_id
4817: AND paa.assignment_id = cp_assignment_id
4826:
4827: CURSOR c_get_prepay_aaid_for_sepchk( cp_asg_act_id NUMBER,
4828: cp_source_act_id NUMBER ) IS
4829: SELECT ppp.assignment_action_id
4830: FROM pay_assignment_actions paa
4831: ,pay_pre_payments ppp
4832: WHERE ( paa.assignment_action_id = cp_asg_act_id OR
4833: paa.source_action_id = cp_asg_act_id )
4834: AND ppp.assignment_action_id = paa.assignment_action_id
4839: ,cp_assignment_id NUMBER
4840: ,cp_tax_unit_id NUMBER) IS
4841: SELECT paa.assignment_action_id
4842: ,paa.source_action_id
4843: FROM pay_assignment_actions paa
4844: ,pay_action_interlocks pai
4845: WHERE pai.locking_action_id = cp_pp_asg_act_id
4846: AND paa.assignment_action_id = pai.locked_action_id
4847: AND paa.assignment_id = cp_assignment_id
4851: CURSOR c_all_runs(cp_pp_asg_act_id IN NUMBER
4852: ,cp_assignment_id IN NUMBER
4853: ,cp_tax_unit_id IN NUMBER) IS
4854: SELECT paa.assignment_action_id
4855: FROM pay_assignment_actions paa,
4856: pay_action_interlocks pai
4857: WHERE pai.locking_action_id = cp_pp_asg_act_id
4858: AND paa.assignment_action_id = pai.locked_action_id
4859: AND paa.assignment_id = cp_assignment_id
5095: FETCH c_get_prepay_aaid_for_sepchk INTO ln_asg_action_id;
5096: CLOSE c_get_prepay_aaid_for_sepchk;
5097:
5098: ln_step := 12;
5099: SELECT pay_assignment_actions_s.nextval
5100: INTO ln_child_xfr_action_id
5101: FROM dual;
5102:
5103: hr_utility.set_location(gv_package || lv_procedure_name, 30);
5101: FROM dual;
5102:
5103: hr_utility.set_location(gv_package || lv_procedure_name, 30);
5104:
5105: -- insert into pay_assignment_actions.
5106:
5107: ln_step := 13;
5108:
5109:
5134: lv_master_sepcheck_flag || ln_source_action_id;
5135:
5136: ln_step := 16;
5137:
5138: update pay_assignment_actions
5139: set serial_number = lv_serial_number
5140: WHERE assignment_action_id = ln_child_xfr_action_id;
5141:
5142: hr_utility.trace('Processing Child action ' ||