APPS.PSB_WS_POS3 dependencies on PSB_WS_ACCOUNT_LINES

Line 4001: select /*+ ORDERED INDEX(a PSB_WS_ACCOUNT_LINES_N5) */

3997:
3998: l_return_status VARCHAR2(1);
3999:
4000: cursor c_Salary_Dist is
4001: select /*+ ORDERED INDEX(a PSB_WS_ACCOUNT_LINES_N5) */
4002: code_combination_id,
4003: budget_group_id,
4004: ytd_amount
4005: from PSB_WS_ACCOUNT_LINES a

Line 4005: from PSB_WS_ACCOUNT_LINES a

4001: select /*+ ORDERED INDEX(a PSB_WS_ACCOUNT_LINES_N5) */
4002: code_combination_id,
4003: budget_group_id,
4004: ytd_amount
4005: from PSB_WS_ACCOUNT_LINES a
4006: where salary_account_line = 'Y'
4007: and p_current_stage_seq between start_stage_seq and current_stage_seq
4008: and currency_code = p_func_currency
4009: and 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 4057: from PSB_WS_ACCOUNT_LINES a,

4053: a.period49_amount, a.period50_amount, a.period51_amount,
4054: a.period52_amount, a.period53_amount, a.period54_amount,
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