DBA Data[Home] [Help]

APPS.PSB_GL_INTERFACE_PVT dependencies on PSB_WS_LINES

Line 1998: psb_ws_lines b,

1994: 11, NVL(period11_amount, 0),
1995: 12, NVL(period12_amount, 0)
1996: ) x_amount
1997: FROM psb_ws_account_lines a,
1998: psb_ws_lines b,
1999: psb_service_packages d
2000: WHERE a.budget_year_id = p_budget_year_id
2001: AND a.balance_type = 'E'
2002: AND a.template_id IS NULL

Line 2079: psb_ws_lines b,

2075: 12, NVL(period12_amount, 0)
2076: )
2077: ) x_amount
2078: FROM psb_ws_account_lines a,
2079: psb_ws_lines b,
2080: psb_service_packages d
2081: WHERE a.budget_year_id = p_year_id
2082: AND a.balance_type = 'E'
2083: AND a.template_id IS NULL

Line 3210: 'FROM PSB_WS_ACCOUNT_LINES a, PSB_WS_LINES b ' ||

3206: BEGIN
3207:
3208: OPEN fb_cv FOR
3209: 'SELECT a.code_combination_id ' ||
3210: 'FROM PSB_WS_ACCOUNT_LINES a, PSB_WS_LINES b ' ||
3211: 'WHERE b.worksheet_id = :source_id ' ||
3212: l_curr_string|| -- Bug 3029168
3213: 'AND b.account_line_id = a.account_line_id ' ||
3214: 'AND a.budget_year_id = :budget_year_id ' ||