[Home] [Help]
453: elsif (p_period_type = 'PERIOD') then
454: --
455: select start_date
456: into l_return_date
457: from per_time_periods
458: where payroll_id = p_payroll_id
459: and p_effective_date between start_date
460: and end_date;
461: --
604: elsif (p_period_type = 'PERIOD') then
605: --
606: select end_date
607: into l_return_date
608: from per_time_periods
609: where payroll_id = p_payroll_id
610: and p_effective_date between start_date
611: and end_date;
612: --
5519: l_bus_grp_id per_all_assignments_f.business_group_id%type;
5520: l_consol_set_id pay_all_payrolls_f.payroll_id%type;
5521: l_ass_action_id pay_assignment_actions.assignment_action_id%type;
5522: l_pay_action_id pay_payroll_actions.payroll_action_id%type;
5523: l_time_period_id per_time_periods.time_period_id%type;
5524: l_asg_lock boolean;
5525: --
5526: begin
5527: g_debug := hr_utility.debug_enabled;
5568: hr_utility.set_location ('pay_balance_pkg.get_value', 12);
5569: end if;
5570: select TIMEP.time_period_id
5571: into l_time_period_id
5572: from per_time_periods TIMEP
5573: where TIMEP.payroll_id = l_payroll_id
5574: and p_virtual_date between TIMEP.start_date
5575: and TIMEP.end_date;
5576: exception
6593: , prr.local_unit_id local_unit_id
6594: , ppa.effective_date
6595: from pay_assignment_actions paa,
6596: pay_payroll_actions ppa,
6597: per_time_periods ptp,
6598: pay_run_results prr
6599: where paa.assignment_action_id = p_asg_action
6600: and ppa.payroll_action_id = paa.payroll_action_id
6601: and paa.assignment_action_id = prr.assignment_action_id
7505: , prr.time_definition_id
7506: , nvl(prr.end_date, ptp.end_date) balance_date
7507: from pay_assignment_actions paa,
7508: pay_payroll_actions ppa,
7509: per_time_periods ptp,
7510: pay_run_results prr
7511: where paa.assignment_action_id = asgact
7512: and paa.assignment_action_id = prr.assignment_action_id
7513: and ppa.payroll_action_id = paa.payroll_action_id
7800: 'Y', find_context('ORGANIZATION_ID', prr.run_result_id),
7801: null) organization_id
7802: from pay_assignment_actions paa,
7803: pay_payroll_actions ppa,
7804: per_time_periods ptp,
7805: pay_run_results prr
7806: where paa.payroll_action_id = p_pact_id
7807: and paa.assignment_action_id = prr.assignment_action_id
7808: and ppa.payroll_action_id = paa.payroll_action_id
8221: , nvl(prr.end_date, ptp.end_date) balance_date
8222: , prr.local_unit_id local_unit_id
8223: from pay_assignment_actions paa,
8224: pay_payroll_actions ppa,
8225: per_time_periods ptp,
8226: pay_run_results prr
8227: where paa.payroll_action_id = p_pact_id
8228: and paa.assignment_action_id = prr.assignment_action_id
8229: and ppa.payroll_action_id = paa.payroll_action_id
8609: 'Y', prr.local_unit_id,
8610: null) local_unit_id
8611: from pay_assignment_actions paa,
8612: pay_payroll_actions ppa,
8613: per_time_periods ptp,
8614: pay_run_results prr
8615: where paa.assignment_action_id = asgact
8616: and paa.assignment_action_id = prr.assignment_action_id
8617: and ppa.payroll_action_id = paa.payroll_action_id
9060: , nvl(prr.end_date, ptp.end_date) balance_date
9061: , prr.local_unit_id
9062: from pay_assignment_actions paa,
9063: pay_payroll_actions ppa,
9064: per_time_periods ptp,
9065: pay_run_results prr
9066: where paa.assignment_action_id = asgact
9067: and paa.assignment_action_id = prr.assignment_action_id
9068: and ppa.payroll_action_id = paa.payroll_action_id
9609: , prr.local_unit_id
9610: from pay_assignment_actions paa,
9611: pay_run_results prr,
9612: pay_payroll_actions ppa,
9613: per_time_periods ptp
9614: where ppa.payroll_action_id = p_pact_id
9615: and paa.payroll_action_id = ppa.payroll_action_id
9616: and paa.assignment_action_id = prr.assignment_action_id
9617: and ptp.payroll_id = ppa.payroll_id