APPS.HRI_OLTP_DISC_WRKFRC dependencies on PER_TIME_PERIODS

Line 127: FROM per_time_periods tp

123: WHERE b.budget_id = p_budget_id;
124:
125: CURSOR time_period_csr IS
126: SELECT tp.end_date
127: FROM per_time_periods tp
128: WHERE tp.time_period_id = p_time_period_id;
129:
130: /* 115.22 - replaced NVL logic with ORs */
131: /*----------------------------------------------------------------------------*/

Line 239: l_period_end_date per_time_periods.end_date%type;

235: l_formula_id ff_formulas_f.formula_id%type;
236: l_grade_id per_budget_elements.grade_id%type;
237: l_job_id per_budget_elements.job_id%type;
238: l_organization_id per_budget_elements.organization_id%type;
239: l_period_end_date per_time_periods.end_date%type;
240: l_position_id per_budget_elements.position_id%type;
241:
242: BEGIN
243:

Line 471: from per_time_periods tp, pqh_budget_periods bpr

467: AND bgt.budget_unit3_id = pst3.shared_type_id (+);
468:
469: cursor time_period_csr is
470: select tp.end_date
471: from per_time_periods tp, pqh_budget_periods bpr
472: where bpr.budget_period_id = p_time_period_id
473: and tp.time_period_id = bpr.end_time_period_id;
474:
475: /* 115.22 - replaced NVL logic with ORs */

Line 591: l_period_end_date per_time_periods.end_date%type;

587: l_formula_id ff_formulas_f.formula_id%type;
588: l_grade_id per_budget_elements.grade_id%type;
589: l_job_id per_budget_elements.job_id%type;
590: l_organization_id per_budget_elements.organization_id%type;
591: l_period_end_date per_time_periods.end_date%type;
592: l_position_id per_budget_elements.position_id%type;
593: p_formula_id ff_formulas_x.formula_id%type;
594:
595: BEGIN

Line 1060: l_period_end_date per_time_periods.end_date%type;

1056: l_formula_id ff_formulas_f.formula_id%type;
1057: l_grade_id per_budget_elements.grade_id%type;
1058: l_job_id per_budget_elements.job_id%type;
1059: l_organization_id per_budget_elements.organization_id%type;
1060: l_period_end_date per_time_periods.end_date%type;
1061: l_position_id per_budget_elements.position_id%type;
1062: p_formula_id ff_formulas_x.formula_id%type;
1063:
1064: BEGIN