DBA Data[Home] [Help]

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_PAY_ELEMENT_OPTIONS

Line 8314: from PSB_PAY_ELEMENT_OPTIONS

8310:
8311: cursor c_Grade is
8312: select name grade_name,
8313: grade_step
8314: from PSB_PAY_ELEMENT_OPTIONS
8315: where pay_element_option_id = p_pay_element_option_id;
8316:
8317: cursor c_SalaryNeqAll is
8318: select a.name position_name,

Line 8322: PSB_PAY_ELEMENT_OPTIONS b,

8318: select a.name position_name,
8319: b.name,
8320: b.grade_step
8321: from PSB_POSITIONS a,
8322: PSB_PAY_ELEMENT_OPTIONS b,
8323: PSB_POSITION_ASSIGNMENTS c
8324: where exists
8325: (select 1
8326: from PSB_BUDGET_POSITIONS d,

Line 8341: from PSB_PAY_ELEMENT_OPTIONS a,

8337:
8338: cursor c_SalaryNeq is
8339: select a.name,
8340: a.grade_step
8341: from PSB_PAY_ELEMENT_OPTIONS a,
8342: PSB_POSITION_ASSIGNMENTS b
8343: where a.pay_element_option_id = b.pay_element_option_id
8344: and b.pay_element_option_id <> p_pay_element_option_id
8345: and b.pay_element_id = p_pay_element_id