APPS.PSB_WS_POS3 dependencies on PSB_POSITION_ASSIGNMENTS

Line 536: from PSB_POSITION_ASSIGNMENTS pa,

532: from PSB_POSITIONS pp
533: where pp.data_extract_id = l_data_extract_id
534: and exists
535: (select 1
536: from PSB_POSITION_ASSIGNMENTS pa,
537: PSB_PARAMETER_FORMULAS pf
538: where pa.position_id = pp.position_id
539: and pa.data_extract_id = pp.data_extract_id
540: and pa.assignment_type = 'ELEMENT'

Line 2676: from PSB_POSITION_ASSIGNMENTS

2672: effective_end_date,
2673: element_value_type,
2674: element_value,
2675: pay_basis
2676: from PSB_POSITION_ASSIGNMENTS
2677: where worksheet_id is null
2678: and currency_code = p_currency_code
2679: and ((p_pay_element_option_id is null) or (pay_element_option_id = p_pay_element_option_id))
2680: and (((effective_start_date <= p_end_date)

Line 3240: from PSB_POSITION_ASSIGNMENTS a,

3236: a.pay_basis,
3237: /* For Bug No. 2263220 : Start */
3238: b.option_flag
3239: /* For Bug No. 2263220 : End */
3240: from PSB_POSITION_ASSIGNMENTS a,
3241: PSB_PAY_ELEMENTS b
3242: where a.worksheet_id is null
3243: and a.currency_code = p_currency_code
3244: and (((p_end_date is not null)

Line 5253: PSB_POSITION_ASSIGNMENTS c

5249: b.name,
5250: b.grade_step
5251: from PSB_POSITIONS a,
5252: PSB_PAY_ELEMENT_OPTIONS b,
5253: PSB_POSITION_ASSIGNMENTS c
5254: where exists
5255: (select 1
5256: from PSB_BUDGET_POSITIONS d,
5257: PSB_SET_RELATIONS e

Line 5278: PSB_POSITION_ASSIGNMENTS b

5274: cursor c_SalaryNeq is
5275: select a.name,
5276: a.grade_step
5277: from PSB_PAY_ELEMENT_OPTIONS a,
5278: PSB_POSITION_ASSIGNMENTS b
5279: where a.pay_element_option_id = b.pay_element_option_id
5280: and b.pay_element_option_id <> p_pay_element_option_id
5281: and (((b.effective_start_date <= p_year_start_date)
5282: and (b.effective_end_date is null))