DBA Data[Home] [Help]

APPS.PSB_WS_POS3 dependencies on PSB_CONSTRAINT_FORMULAS

Line 4647: from PSB_CONSTRAINT_FORMULAS

4643: pay_element_option_id,
4644: nvl(effective_start_date, p_start_date) effective_start_date,
4645: nvl(effective_end_date, p_end_date) effective_end_date,
4646: allow_modify
4647: from PSB_CONSTRAINT_FORMULAS
4648: where constraint_id = p_constraint_id
4649: order by step_number;
4650:
4651: cursor c_Positions is

Line 5123: from PSB_CONSTRAINT_FORMULAS

5119: prefix_operator,
5120: nvl(currency_code, p_currency_code) currency_code,
5121: element_value_type,
5122: element_value
5123: from PSB_CONSTRAINT_FORMULAS
5124: where constraint_id = p_constraint_id
5125: order by step_number;
5126:
5127: BEGIN

Line 5879: from PSB_CONSTRAINT_FORMULAS

5875:
5876: cursor c_Formula is
5877: select prefix_operator,
5878: amount
5879: from PSB_CONSTRAINT_FORMULAS
5880: where constraint_id = p_constraint_id;
5881:
5882: cursor c_SumAll is
5883: select sum(nvl(a.annual_fte, 0)) Sum_FTE