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_COMMITMENT_POSTING dependencies on PER_TIME_PERIODS

Line 147: From per_time_periods

143: Where budget_period_id = p_budget_period_id;
144: --
145: Cursor csr_period_date(p_time_period_id in number) is
146: Select start_date,end_date
147: From per_time_periods
148: Where time_period_id = p_time_period_id;
149: --
150: l_start_time_period_id pqh_budget_periods.start_time_period_id%TYPE;
151: l_end_time_period_id pqh_budget_periods.end_time_period_id%TYPE;

Line 1400: l_period_start_date per_time_periods.start_date%type := NULL;

1396: p_budget_unit_seq IN number,
1397: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,
1398: p_effective_date IN varchar2) IS
1399: --
1400: l_period_start_date per_time_periods.start_date%type := NULL;
1401: l_period_end_date per_time_periods.end_date%type := NULL;
1402: l_commitment number := NULL;
1403: l_distribution_table t_distribution_table;
1404: l_budget_ratio_table t_ratio_table;

Line 1401: l_period_end_date per_time_periods.end_date%type := NULL;

1397: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,
1398: p_effective_date IN varchar2) IS
1399: --
1400: l_period_start_date per_time_periods.start_date%type := NULL;
1401: l_period_end_date per_time_periods.end_date%type := NULL;
1402: l_commitment number := NULL;
1403: l_distribution_table t_distribution_table;
1404: l_budget_ratio_table t_ratio_table;
1405: l_budget_entity pqh_budgets.budgeted_entity_cd%type := NULL;

Line 1426: -- Obtain the start and end date of the period from per_time_periods

1422: hr_utility.set_location('Entering: '||l_proc, 5);
1423: --
1424: l_effective_dt := fnd_date.canonical_to_date(p_effective_date);
1425: --
1426: -- Obtain the start and end date of the period from per_time_periods
1427: --
1428: get_period_dates(p_budget_period_id => p_budget_period_id,
1429: p_period_start_date => l_period_start_date,
1430: p_period_end_date => l_period_end_date);

Line 1508: l_period_start_date per_time_periods.start_date%type := NULL;

1504: p_budget_unit_seq IN number,
1505: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,
1506: p_effective_date IN varchar2) IS
1507: --
1508: l_period_start_date per_time_periods.start_date%type := NULL;
1509: l_period_end_date per_time_periods.end_date%type := NULL;
1510: --
1511: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
1512: l_budget_entity pqh_budgets.budgeted_entity_cd%type := NULL;

Line 1509: l_period_end_date per_time_periods.end_date%type := NULL;

1505: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%type,
1506: p_effective_date IN varchar2) IS
1507: --
1508: l_period_start_date per_time_periods.start_date%type := NULL;
1509: l_period_end_date per_time_periods.end_date%type := NULL;
1510: --
1511: l_element_type_id pay_element_types_f.element_type_id%TYPE := NULL;
1512: l_budget_entity pqh_budgets.budgeted_entity_cd%type := NULL;
1513: l_business_group_id pqh_budgets.business_group_id%type := NULL;

Line 1550: -- Obtain the start and end date of the period from per_time_periods

1546: --
1547: l_effective_dt := fnd_date.canonical_to_date(p_effective_date);
1548: --
1549: hr_utility.set_location('UOM : '||to_char(p_unit_of_measure_id),7);
1550: -- Obtain the start and end date of the period from per_time_periods
1551: --
1552: get_period_dates(p_budget_period_id => p_budget_period_id,
1553: p_period_start_date => l_period_start_date,
1554: p_period_end_date => l_period_end_date);

Line 1947: FROM per_time_periods

1943: l_gl_period_statuses_rec gl_period_statuses%ROWTYPE;
1944: --
1945: CURSOR csr_time_period IS
1946: SELECT start_date
1947: FROM per_time_periods
1948: WHERE time_period_id = ( SELECT start_time_period_id
1949: FROM pqh_budget_periods
1950: WHERE budget_period_id = p_budget_period_id );
1951: --