[Home] [Help]
34: for the payroll id found associated with the assignment
35:
36: cursor csr_last_dt is
37: Select NVL( max( tp.end_date), p_start_date )
38: From per_time_periods tp,
39: pay_payroll_actions ppa,
40: per_all_assignments_f aaf
41: Where aaf.assignment_id = p_assignment_id
42: and (aaf.effective_end_date >= p_start_date and aaf.effective_start_date <= p_end_date)
56: from pay_assignment_actions paa,
57: per_all_assignments_f paf,
58: pay_payroll_actions ppa,
59: pay_action_classifications pac,
60: per_time_periods tp
61: where paf.assignment_id = p_assignment_id
62: and (paf.effective_end_date >= p_start_date
63: and paf.effective_start_date <= p_end_date)
64: and paa.assignment_id = paf.assignment_id
780: PAY_ELEMENT_TYPES_F PET,
781: PAY_RUN_RESULTS RES,
782: (
783: Select tp.start_date, tp.end_date, aac.assignment_action_id
784: From per_time_periods tp,
785: pay_payroll_actions ppa,
786: PAY_ASSIGNMENT_ACTIONS AAC
787: Where tp.payroll_id=p_payroll_id
788: AND (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
818: PAY_ELEMENT_TYPES_F PET,
819: PAY_RUN_RESULTS RES,
820: (
821: Select tp.start_date, tp.end_date, aac.assignment_action_id
822: From per_time_periods tp,
823: pay_payroll_actions ppa,
824: PAY_ASSIGNMENT_ACTIONS AAC
825: Where tp.payroll_id=p_payroll_id
826: AND (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
927: PAY_ELEMENT_TYPES_F PET,
928: PAY_RUN_RESULTS RES,
929: (
930: Select tp.start_date, tp.end_date, aac.assignment_action_id
931: From per_time_periods tp,
932: pay_payroll_actions ppa,
933: PAY_ASSIGNMENT_ACTIONS AAC
934: Where tp.payroll_id=p_payroll_id
935: AND (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
1013: IS
1014:
1015: Cursor csr_pay_date Is
1016: Select max(tp.end_date)
1017: From per_time_periods tp,
1018: pay_payroll_actions ppa,
1019: PAY_ASSIGNMENT_ACTIONS AAC
1020: Where tp.payroll_id=p_payroll_id
1021: and (tp.start_date <= p_actuals_end_date and tp.end_date >= p_actuals_start_date)
1321: --
1322: Cursor csr_asg_time_periods is
1323: Select /*+ ORDERED */
1324: tp.start_date,tp.end_date, aac.assignment_action_id
1325: From per_time_periods tp,
1326: pay_payroll_actions ppa,
1327: PAY_ASSIGNMENT_ACTIONS AAC
1328: Where tp.payroll_id=p_payroll_id
1329: AND (tp.start_date <= p_actuals_end_date
1781: IS
1782: --
1783: l_assign_commitment number := 0;
1784: l_assign_actuals number := 0;
1785: l_last_payroll_dt per_time_periods.end_date%type := NULL;
1786: --
1787: l_budget_id pqh_budgets.budget_id%type := NULL;
1788: l_budget_version_id pqh_budget_versions.budget_version_id%type;
1789: --
1935: --
1936: l_position_id pqh_budget_details.position_id%type;
1937: l_position_name hr_all_positions_f.name%type := NULL;
1938: l_assignment_id per_all_assignments_f.assignment_id%type;
1939: l_last_actuals_date per_time_periods.end_date%type;
1940: --
1941: l_budget_id pqh_budgets.budget_id%type := NULL;
1942: --
1943: l_unit_of_measure per_shared_types.system_type_cd%type;
2342: --
2343: l_position_id pqh_budget_details.position_id%type;
2344: l_position_name hr_all_positions_f.name%type := NULL;
2345: l_assignment_id per_all_assignments_f.assignment_id%type;
2346: l_last_actuals_date per_time_periods.end_date%type;
2347: --
2348: l_budget_id pqh_budgets.budget_id%type := NULL;
2349: --
2350: l_unit_of_measure per_shared_types.system_type_cd%type;
2617: --
2618:
2619: l_assignment_id per_all_assignments_f.assignment_id%type;
2620: l_business_group_id per_all_assignments_f.business_group_id%type;
2621: l_last_actuals_date per_time_periods.end_date%type;
2622: --
2623: l_budget_id pqh_budgets.budget_id%type := NULL;
2624: --
2625: l_unit_of_measure per_shared_types.system_type_cd%type;
3708: ,p_assignment_actuals out nocopy number
3709: ,p_assignment_commitment out nocopy number
3710: ,p_assignment_total out nocopy number
3711: ) is
3712: l_last_actuals_date per_time_periods.end_date%type;
3713: l_budget_id pqh_budgets.budget_id%type := NULL;
3714: --
3715: begin
3716: --
3866: --
3867: l_position_id pqh_budget_details.position_id%type;
3868: l_position_name hr_all_positions_f.name%type := NULL;
3869: l_assignment_id per_all_assignments_f.assignment_id%type;
3870: l_last_actuals_date per_time_periods.end_date%type;
3871: --
3872: l_budget_id pqh_budgets.budget_id%type := NULL;
3873: --
3874: l_unit_of_measure per_shared_types.system_type_cd%type;