[Home] [Help]
3135: p_bal_type_id in pay_balance_batch_lines.balance_type_id%TYPE,
3136: p_bal_dimension_id in pay_balance_batch_lines.balance_dimension_id%TYPE,
3137: p_value in pay_balance_batch_lines.value%TYPE,
3138: p_assignment_id in pay_balance_batch_lines.assignment_id%TYPE,
3139: p_asg_act_id in pay_assignment_actions.assignment_action_id%TYPE,
3140: p_tax_unit_id in number,
3141: p_jurisdiction_code in pay_balance_batch_lines.jurisdiction_code%TYPE
3142: default NULL,
3143: p_source_id in number,
3395: cursor csr_get_asg_act (p_act_id in number,
3396: p_asg_id in number)
3397: is
3398: select paa.assignment_action_id
3399: from pay_assignment_actions paa
3400: where paa.assignment_id = p_asg_id
3401: and paa.payroll_action_id = p_act_id;
3402: --
3403: --
3464: select /*+ ORDERED
3465: USE_NL(pbl ppa pbf paa rr rrv)
3466: INDEX(pbl PAY_BALANCE_BATCH_LINES_N51)
3467: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
3468: INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
3469: INDEX(rr PAY_RUN_RESULTS_N50)
3470: INDEX(rrv PAY_RUN_RESULT_VALUES_N50)
3471: INDEX(pbf PAY_BALANCE_FEEDS_F_N2) */
3472: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3474: into l_asg_act_id
3475: from
3476: pay_balance_batch_lines pbl,
3477: pay_payroll_actions ppa,
3478: pay_assignment_actions paa,
3479: pay_run_results rr,
3480: pay_run_result_values rrv,
3481: pay_balance_feeds_f pbf
3482: where pbl.batch_id = p_glbl_data_rec.batch_id
4591: (
4592: p_assignment_id number
4593: ) is
4594: select AA.payroll_action_id
4595: from pay_assignment_actions AA, pay_payroll_actions PAA
4596: where AA.assignment_id = p_assignment_id
4597: and PAA.payroll_action_id = AA.payroll_action_id
4598: and PAA.action_type <> 'BEE';
4599: --
5571: p_assignment_id in number)
5572: is
5573: select ppa.payroll_action_id
5574: from pay_payroll_actions ppa,
5575: pay_assignment_actions paa
5576: where ppa.payroll_id = p_payroll_id
5577: and ppa.action_type <> 'I'
5578: and paa.payroll_action_id = ppa.payroll_action_id
5579: and paa.assignment_id = p_assignment_id;