[Home] [Help]
154: IS
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
535: FROM pay_bal_attribute_definitions pbad,
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,
586: pay_balance_attributes pba,
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,
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',
1483: 'Deductions',
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',
1536: 'Deductions',
2259: AND ppa.effective_date BETWEEN paf.effective_start_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
2330: 'N') = 'N'
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
2381: 'N') = 'N'
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
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
2403: AND ppa.payroll_action_id = paa.payroll_action_id
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
3555: AND paa.assignment_id = cp_assignment_id
4754: AND organization_id = cp_business_group;
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
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
4782: AND paa.source_action_id IS NULL
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
4818: AND paa.tax_unit_id = cp_tax_unit_id
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
4848: AND paa.tax_unit_id = cp_tax_unit_id
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
4860: AND paa.tax_unit_id = cp_tax_unit_id
4867: AND prt.run_method = 'C' );
4868:
4869: CURSOR c_get_emp_adjbal(cp_xfr_action_id NUMBER) IS
4870: SELECT locked_action_id
4871: FROM pay_action_interlocks
4872: WHERE locking_action_id = cp_xfr_action_id;
4873:
4874: ld_curr_pymt_eff_date DATE;
4875: ln_sepchk_run_type_id NUMBER;