eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on PER_TIME_PERIODS

Line 38: From per_time_periods tp,

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)

Line 60: per_time_periods tp

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

Line 784: From per_time_periods tp,

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)

Line 822: From per_time_periods tp,

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)

Line 931: From per_time_periods tp,

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)

Line 1017: From per_time_periods tp,

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)

Line 1322: From per_time_periods tp,

1318: --
1319: Cursor csr_asg_time_periods is
1320: Select /*+ ORDERED */
1321: tp.start_date,tp.end_date, aac.assignment_action_id
1322: From per_time_periods tp,
1323: pay_payroll_actions ppa,
1324: PAY_ASSIGNMENT_ACTIONS AAC
1325: Where tp.payroll_id=p_payroll_id
1326: AND (tp.start_date <= p_actuals_end_date

Line 1782: l_last_payroll_dt per_time_periods.end_date%type := NULL;

1778: IS
1779: --
1780: l_assign_commitment number := 0;
1781: l_assign_actuals number := 0;
1782: l_last_payroll_dt per_time_periods.end_date%type := NULL;
1783: --
1784: l_budget_id pqh_budgets.budget_id%type := NULL;
1785: l_budget_version_id pqh_budget_versions.budget_version_id%type;
1786: --

Line 1936: l_last_actuals_date per_time_periods.end_date%type;

1932: --
1933: l_position_id pqh_budget_details.position_id%type;
1934: l_position_name hr_all_positions_f.name%type := NULL;
1935: l_assignment_id per_all_assignments_f.assignment_id%type;
1936: l_last_actuals_date per_time_periods.end_date%type;
1937: --
1938: l_budget_id pqh_budgets.budget_id%type := NULL;
1939: --
1940: l_unit_of_measure per_shared_types.system_type_cd%type;

Line 2343: l_last_actuals_date per_time_periods.end_date%type;

2339: --
2340: l_position_id pqh_budget_details.position_id%type;
2341: l_position_name hr_all_positions_f.name%type := NULL;
2342: l_assignment_id per_all_assignments_f.assignment_id%type;
2343: l_last_actuals_date per_time_periods.end_date%type;
2344: --
2345: l_budget_id pqh_budgets.budget_id%type := NULL;
2346: --
2347: l_unit_of_measure per_shared_types.system_type_cd%type;

Line 2618: l_last_actuals_date per_time_periods.end_date%type;

2614: --
2615:
2616: l_assignment_id per_all_assignments_f.assignment_id%type;
2617: l_business_group_id per_all_assignments_f.business_group_id%type;
2618: l_last_actuals_date per_time_periods.end_date%type;
2619: --
2620: l_budget_id pqh_budgets.budget_id%type := NULL;
2621: --
2622: l_unit_of_measure per_shared_types.system_type_cd%type;

Line 3709: l_last_actuals_date per_time_periods.end_date%type;

3705: ,p_assignment_actuals out nocopy number
3706: ,p_assignment_commitment out nocopy number
3707: ,p_assignment_total out nocopy number
3708: ) is
3709: l_last_actuals_date per_time_periods.end_date%type;
3710: l_budget_id pqh_budgets.budget_id%type := NULL;
3711: --
3712: begin
3713: --

Line 3867: l_last_actuals_date per_time_periods.end_date%type;

3863: --
3864: l_position_id pqh_budget_details.position_id%type;
3865: l_position_name hr_all_positions_f.name%type := NULL;
3866: l_assignment_id per_all_assignments_f.assignment_id%type;
3867: l_last_actuals_date per_time_periods.end_date%type;
3868: --
3869: l_budget_id pqh_budgets.budget_id%type := NULL;
3870: --
3871: l_unit_of_measure per_shared_types.system_type_cd%type;