APPS.PSB_WS_POS3 dependencies on PSB_PAY_ELEMENTS

Line 1291: PSB_PAY_ELEMENTS b

1287: a.maximum_value,
1288: a.mid_value,
1289: a.minimum_value
1290: from PSB_PAY_ELEMENT_RATES a,
1291: PSB_PAY_ELEMENTS b
1292: where a.worksheet_id is null
1293: and a.currency_code = p_currency_code
1294: and (((a.effective_start_date <= p_end_date)
1295: and (a.effective_end_date is null))

Line 3241: PSB_PAY_ELEMENTS b

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)
3245: and (((a.effective_start_date <= p_end_date)

Line 4015: select /*+ ORDERED USE_NL(a b) INDEX(a PSB_WS_ELEMENT_LINES_N1) INDEX(b PSB_PAY_ELEMENTS_U1) */

4011: and budget_year_id = p_budget_year_id
4012: and position_line_id = p_position_line_id;
4013:
4014: cursor c_Element_Cost is
4015: select /*+ ORDERED USE_NL(a b) INDEX(a PSB_WS_ELEMENT_LINES_N1) INDEX(b PSB_PAY_ELEMENTS_U1) */
4016: a.pay_element_id,
4017: a.element_set_id,
4018: a.element_cost
4019: from PSB_WS_ELEMENT_LINES a,

Line 4020: PSB_PAY_ELEMENTS b

4016: a.pay_element_id,
4017: a.element_set_id,
4018: a.element_cost
4019: from PSB_WS_ELEMENT_LINES a,
4020: PSB_PAY_ELEMENTS b
4021: where p_current_stage_seq between a.start_stage_seq and a.current_stage_seq
4022: and a.currency_code = p_func_currency
4023: and a.pay_element_id = b.pay_element_id
4024: and a.stage_set_id = p_stage_set_id

Line 4033: select /*+ ORDERED USE_NL(a b c) INDEX(a PSB_WS_ACCOUNT_LINES_N5) INDEX(b PSB_WS_ELEMENT_LINES_N1) INDEX(c PSB_PAY_ELEMENTS_U1) */

4029: and b.business_group_id = p_business_group_id
4030: and b.data_extract_id = p_data_extract_id;
4031:
4032: cursor c_Element_Dist is
4033: select /*+ ORDERED USE_NL(a b c) INDEX(a PSB_WS_ACCOUNT_LINES_N5) INDEX(b PSB_WS_ELEMENT_LINES_N1) INDEX(c PSB_PAY_ELEMENTS_U1) */
4034: a.account_line_id,
4035: a.code_combination_id,
4036: a.ytd_amount,
4037: a.period1_amount, a.period2_amount, a.period3_amount,

Line 4059: PSB_PAY_ELEMENTS c

4055: a.period55_amount, a.period56_amount, a.period57_amount,
4056: a.period58_amount, a.period59_amount, a.period60_amount
4057: from PSB_WS_ACCOUNT_LINES a,
4058: PSB_WS_ELEMENT_LINES b,
4059: PSB_PAY_ELEMENTS c
4060: where a.element_set_id = b.element_set_id
4061: and p_current_stage_seq between a.start_stage_seq and a.current_stage_seq
4062: and a.stage_set_id = p_stage_set_id
4063: and a.service_package_id = p_service_package_id

Line 5318: PSB_PAY_ELEMENTS c

5314: cursor c_SumAll_Salary is
5315: select sum(nvl(a.element_cost, 0)) Sum_Elem
5316: from PSB_WS_ELEMENT_LINES a,
5317: PSB_WORKSHEETS b,
5318: PSB_PAY_ELEMENTS c
5319: where exists
5320: (select 1
5321: from PSB_WS_LINES_POSITIONS d,
5322: PSB_WS_POSITION_LINES e,

Line 5376: PSB_PAY_ELEMENTS c

5372: cursor c_SumAllSP_Salary is
5373: select sum(nvl(a.element_cost, 0)) Sum_Elem
5374: from PSB_WS_ELEMENT_LINES a,
5375: PSB_WORKSHEETS b,
5376: PSB_PAY_ELEMENTS c
5377: where exists
5378: (select 1
5379: from PSB_WS_LINES_POSITIONS d,
5380: PSB_WS_POSITION_LINES e,

Line 5424: PSB_PAY_ELEMENTS c

5420: select /*+ ORDERED INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5421: sum(nvl(a.element_cost, 0)) Sum_Elem
5422: from PSB_WS_ELEMENT_LINES a,
5423: PSB_WORKSHEETS b,
5424: PSB_PAY_ELEMENTS c
5425: where a.currency_code = p_currency_code
5426: and a.stage_set_id = b.stage_set_id
5427: and a.pay_element_id = c.pay_element_id
5428: and b.current_stage_seq between a.start_stage_seq and a.current_stage_seq

Line 5460: PSB_PAY_ELEMENTS c

5456: select /*+ ORDERED INDEX(a PSB_WS_ELEMENT_LINES_N1) */
5457: sum(nvl(a.element_cost, 0)) Sum_Elem
5458: from PSB_WS_ELEMENT_LINES a,
5459: PSB_WORKSHEETS b,
5460: PSB_PAY_ELEMENTS c
5461: where exists
5462: (select 1
5463: from PSB_WS_SUBMIT_SERVICE_PACKAGES d
5464: where d.service_package_id = a.service_package_id