DBA Data[Home] [Help]

APPS.PSB_EXCEL2_PVT dependencies on PSB_PAY_ELEMENTS

Line 2098: PSB_PAY_ELEMENTS b

2094: a.formula_id,
2095: a.effective_start_date,
2096: a.effective_end_date
2097: from PSB_PAY_ELEMENT_RATES a,
2098: PSB_PAY_ELEMENTS b
2099: where (a.worksheet_id is null or a.worksheet_id = g_global_worksheet_id)
2100: and a.currency_code = g_currency_code
2101: and exists
2102: (select 1

Line 3647: PSB_PAY_ELEMENTS b

3643: abs(l_new_element_value - a.element_value) near_el,
3644: a.pay_element_id,
3645: a.pay_element_option_id
3646: from PSB_PAY_ELEMENT_RATES a,
3647: PSB_PAY_ELEMENTS b
3648: where (a.worksheet_id is null or a.worksheet_id = g_global_worksheet_id)
3649: and a.currency_code = g_currency_code
3650: and (((a.effective_start_date <= l_budget_period_end_date)
3651: and (a.effective_end_date is null))