[Home] [Help]
1410: -- csr_direct deposit date gets the default bank deposit date
1411: --
1412: cursor csr_deposit_date (p_payroll_id number, p_latest_date_earned date) is
1413: select default_dd_date
1414: from per_time_periods
1415: where payroll_id = p_payroll_id
1416: and p_latest_date_earned between start_date and end_date;
1417: --
1418: -- If there has already been a mag tape transfer, get the transfer date from
2480: 'RR',rr_ret.end_date)
2481: ) result_rollup
2482: ,pay_assignment_actions paa
2483: ,pay_payroll_actions ppa
2484: ,per_time_periods ptp
2485: where paa.assignment_action_id (+) = result_rollup.retro_act_id
2486: and ppa.payroll_action_id (+) = paa.payroll_action_id
2487: and ptp.time_period_id (+) = ppa.time_period_id
2488: group by result_rollup.start_date
3581: ,pay_assignment_actions run_assact
3582: ,pay_action_interlocks arc_lock
3583: ,pay_action_interlocks pre_lock
3584: ,pay_entry_process_details epd
3585: ,per_time_periods ptp_date
3586: ,pay_payroll_actions ppa_date
3587: ,pay_assignment_actions paa_date
3588: where epd.element_entry_id = prr.element_entry_id
3589: and epd.retro_component_id is not null