[Home] [Help]
2323: AND fdi.user_name = c_user_name;
2324:
2325: CURSOR get_archived_values(
2326: c_user_entity_id ff_database_items.user_entity_id%type,
2327: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2328: c_tax_unit_id hr_organization_units.organization_id%type)
2329: IS
2330: SELECT target.value
2331: FROM ff_archive_item_contexts con2,
2341: /*context of tax_unit_id */
2342:
2343: CURSOR get_jd_archived_values(
2344: c_user_entity_id ff_database_items.user_entity_id%type,
2345: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2346: c_tax_unit_id hr_organization_units.organization_id%type,
2347: c_jurisdiction_code varchar2)
2348: IS
2349: SELECT target.value
2837: l_effective_start_date pay_payroll_actions.effective_date%TYPE;
2838: l_effective_end_date pay_payroll_actions.effective_date%TYPE;
2839: l_exists varchar2(1);
2840:
2841: CURSOR get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
2842: IS
2843: select add_months(effective_date,-12)+1,effective_date
2844: from pay_payroll_actions ppa,
2845: pay_assignment_actions paa
2841: CURSOR get_effective_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
2842: IS
2843: select add_months(effective_date,-12)+1,effective_date
2844: from pay_payroll_actions ppa,
2845: pay_assignment_actions paa
2846: where ppa.payroll_action_id = paa.payroll_action_id
2847: and paa.assignment_action_id = c_assignment_action_id;
2848:
2849: /*Bug:3233249*/
2988:
2989: select count(*)
2990: into lv_employee_count
2991: from pay_payroll_actions ppa,
2992: pay_assignment_actions paa
2993: where ppa.payroll_action_id = p_payroll_action_id
2994: and paa.tax_unit_id = p_tax_unit_id
2995: and ppa.payroll_action_id = paa.payroll_action_id ;
2996:
3010:
3011: cursor get_all_assignment (cur_payroll_action_id number, cur_tax_unit_id number)
3012: is
3013: Select paa.assignment_action_id
3014: from pay_assignment_actions paa
3015: where payroll_action_id = cur_payroll_action_id
3016: and tax_unit_id = cur_tax_unit_id;
3017:
3018: BEGIN
3059: SELECT count(*)
3060: FROM ff_archive_item_contexts faic,
3061: ff_archive_items fai,
3062: ff_database_items fdi,
3063: pay_assignment_actions paa,
3064: pay_payroll_actions ppa
3065: WHERE
3066: ppa.payroll_action_id = p_payroll_action_id
3067: and ppa.payroll_action_id = paa.payroll_action_id
3101: --sum(to_number(nvl( fai1.value,'0')))
3102: FROM ff_archive_item_contexts faic,
3103: ff_archive_items fai,
3104: ff_database_items fdi,
3105: pay_assignment_actions paa,
3106: pay_payroll_actions ppa,
3107: ff_archive_items fai1,
3108: ff_database_items fdi1,
3109: ff_archive_item_contexts faic1,
3169: sum(to_number(nvl(fai1.value,'0')))
3170: FROM ff_archive_item_contexts faic,
3171: ff_archive_items fai,
3172: ff_database_items fdi,
3173: pay_assignment_actions paa,
3174: pay_payroll_actions ppa,
3175: ff_archive_items fai1,
3176: ff_database_items fdi1,
3177: ff_archive_item_contexts faic1,
3239: sum(to_number(nvl(fai1.value,'0')))
3240: FROM ff_archive_item_contexts faic,
3241: ff_archive_items fai,
3242: ff_database_items fdi,
3243: pay_assignment_actions paa,
3244: pay_payroll_actions ppa,
3245: ff_archive_items fai1,
3246: ff_database_items fdi1
3247: --ff_archive_item_contexts faic1,
3318:
3319: select sum(to_number(nvl(fai.value, '0')) - to_number(nvl(fai1.value, '0')))
3320: into lv_total_wages
3321: from pay_payroll_actions ppa,
3322: pay_assignment_actions paa,
3323: ff_archive_items fai,
3324: ff_archive_items fai1,
3325: ff_database_items fdi,
3326: ff_database_items fdi1
3448: - to_number(nvl(fai2.value, '0'))
3449: ),0)
3450: into p_excess_wages
3451: from pay_payroll_actions ppa,
3452: pay_assignment_actions paa,
3453: ff_archive_items fai,
3454: ff_archive_items fai1,
3455: ff_archive_items fai2,
3456: ff_database_items fdi,
3471:
3472: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3473: into p_withholding
3474: from pay_payroll_actions ppa,
3475: pay_assignment_actions paa,
3476: ff_archive_items fai,
3477: ff_database_items fdi
3478: where ppa.payroll_action_id = p_payroll_action_id
3479: and ppa.payroll_action_id = paa.payroll_action_id
3487: + to_number(nvl(fai2.value, '0'))
3488: ),0)
3489: into p_workerscomp
3490: from pay_payroll_actions ppa,
3491: pay_assignment_actions paa,
3492: ff_archive_items fai,
3493: ff_archive_items fai1,
3494: ff_archive_items fai2,
3495: ff_database_items fdi,
3549: p_sui_pre_tax,
3550: p_sui_taxable,
3551: p_sui_gross
3552: from pay_payroll_actions ppa,
3553: pay_assignment_actions paa,
3554: ff_archive_items fai,
3555: ff_archive_items fai1,
3556: ff_archive_items fai2,
3557: ff_archive_items fai3,
3587:
3588: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3589: into p_sui_taxable
3590: from pay_payroll_actions ppa,
3591: pay_assignment_actions paa,
3592: ff_archive_items fai,
3593: ff_database_items fdi
3594: where ppa.payroll_action_id = p_payroll_action_id
3595: and ppa.payroll_action_id = paa.payroll_action_id
3615:
3616: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3617: into p_sui_taxable
3618: from pay_payroll_actions ppa,
3619: pay_assignment_actions paa,
3620: ff_archive_items fai,
3621: ff_database_items fdi
3622: where ppa.payroll_action_id = p_payroll_action_id
3623: and ppa.payroll_action_id = paa.payroll_action_id