APPS.PSB_EXCEL_PVT dependencies on PSB_PAY_ELEMENTS

Line 1357: PSB_PAY_ELEMENTS b

1353: a.formula_id,
1354: a.effective_start_date,
1355: a.effective_end_date
1356: from PSB_PAY_ELEMENT_RATES a,
1357: PSB_PAY_ELEMENTS b
1358: where (a.worksheet_id is null or a.worksheet_id = g_global_worksheet_id)
1359: and a.currency_code = g_currency_code
1360: and a.element_value_type = 'PS'
1361: and exists

Line 1876: FROM psb_ws_element_lines wel, psb_pay_elements_v pe

1872: --Get Element name (Code taken from post query in POS WS form)
1873: FOR pay_element_rec IN
1874: (
1875: SELECT distinct pe.pay_element_id, pe.name, pe.follow_salary, pe.element_value_type, pe.period_type
1876: FROM psb_ws_element_lines wel, psb_pay_elements_v pe
1877: WHERE wel.position_line_id = l_position_line_id
1878: AND wel.element_set_id = l_element_set_id
1879: AND wel.pay_element_id = pe.pay_element_id)
1880: LOOP