APPS.PSB_EXCEL2_PVT dependencies on PSB_WS_LINE_BALANCES_I

Line 634: from psb_ws_line_balances_i

630:
631: PROCEDURE Set_SPID_ALL_WLBI IS
632: cursor wlbi_cur is
633: select service_package_name
634: from psb_ws_line_balances_i
635: where export_id = g_export_id
636: and export_worksheet_type = 'P'
637: and service_package_id is NULL
638: for update of service_package_id;

Line 669: update psb_ws_line_balances_i

665: p_spid => l_service_package_id
666: );
667: END IF;
668:
669: update psb_ws_line_balances_i
670: set service_package_id = l_service_package_id
671: where current of wlbi_cur;
672:
673: END LOOP;

Line 869: FROM PSB_WS_LINE_BALANCES_I

865: SUM(AMOUNT9) AMOUNT9,
866: SUM(AMOUNT10) AMOUNT10,
867: SUM(AMOUNT11) AMOUNT11,
868: SUM(AMOUNT12) AMOUNT12
869: FROM PSB_WS_LINE_BALANCES_I
870: WHERE EXPORT_ID = g_export_id
871: AND EXPORT_WORKSHEET_TYPE = 'A'
872: AND NVL(POSITION_ACCOUNT_FLAG,'N') = 'N'
873: GROUP BY CONCATENATED_ACCOUNT,

Line 1366: from psb_ws_line_balances_i

1362:
1363: -- Drive the process with Positions
1364: FOR position_rec in
1365: ( select distinct position_line_id
1366: from psb_ws_line_balances_i
1367: where export_id = g_export_id
1368: and export_worksheet_type = 'P'
1369: )
1370: LOOP

Line 1514: FROM psb_ws_line_balances_i

1510: AMOUNT151 a151,AMOUNT152 a152,AMOUNT153 a153,AMOUNT154 a154,AMOUNT155 a155,
1511: AMOUNT156 a156,AMOUNT157 a157,AMOUNT158 a158,AMOUNT159 a159,AMOUNT160 a160,
1512: AMOUNT161 a161,AMOUNT162 a162,AMOUNT163 a163,AMOUNT164 a164,AMOUNT165 a165,
1513: AMOUNT166 a166,AMOUNT167 a167,AMOUNT168 a168
1514: FROM psb_ws_line_balances_i
1515: WHERE export_worksheet_type = 'P'
1516: AND export_id = g_export_id
1517: AND value_type = 'A' -- process only Amount rows
1518: ORDER BY position_line_id, salary_account_line ,code_combination_id

Line 2329: FROM psb_ws_line_balances_i

2325:
2326: FOR element_rec IN
2327: (
2328: SELECT distinct pay_element_id
2329: FROM psb_ws_line_balances_i
2330: WHERE position_line_id = p_position_line_id
2331: AND export_worksheet_type = 'P'
2332: AND export_id = g_export_id
2333: )

Line 2393: FROM psb_ws_line_balances_i

2389: SUM(AMOUNT151) a151,SUM(AMOUNT152) a152,SUM(AMOUNT153) a153,SUM(AMOUNT154) a154,SUM(AMOUNT155) a155,
2390: SUM(AMOUNT156) a156,SUM(AMOUNT157) a157,SUM(AMOUNT158) a158,SUM(AMOUNT159) a159,SUM(AMOUNT160) a160,
2391: SUM(AMOUNT161) a161,SUM(AMOUNT162) a162,SUM(AMOUNT163) a163,SUM(AMOUNT164) a164,SUM(AMOUNT165) a165,
2392: SUM(AMOUNT166) a166,SUM(AMOUNT167) a167,SUM(AMOUNT168) a168
2393: FROM psb_ws_line_balances_i
2394: WHERE position_line_id = p_position_line_id
2395: AND export_worksheet_type = 'P'
2396: AND export_id = g_export_id
2397: /* For Bug No. 2378123 : Start */

Line 2717: from psb_ws_line_balances_i

2713: BEGIN
2714:
2715: FOR sp_rec IN
2716: ( select distinct service_package_id
2717: from psb_ws_line_balances_i
2718: where export_id = g_export_id
2719: and export_worksheet_type = 'P'
2720: and position_line_id = p_position_line_id
2721: and pay_element_id = p_pay_element_id

Line 2764: FROM psb_ws_line_balances_i

2760: SUM(AMOUNT151) a151,SUM(AMOUNT152) a152,SUM(AMOUNT153) a153,SUM(AMOUNT154) a154,SUM(AMOUNT155) a155,
2761: SUM(AMOUNT156) a156,SUM(AMOUNT157) a157,SUM(AMOUNT158) a158,SUM(AMOUNT159) a159,SUM(AMOUNT160) a160,
2762: SUM(AMOUNT161) a161,SUM(AMOUNT162) a162,SUM(AMOUNT163) a163,SUM(AMOUNT164) a164,SUM(AMOUNT165) a165,
2763: SUM(AMOUNT166) a166,SUM(AMOUNT167) a167,SUM(AMOUNT168) a168
2764: FROM psb_ws_line_balances_i
2765: WHERE export_id = g_export_id
2766: AND export_worksheet_type = 'P'
2767: AND position_line_id = p_position_line_id
2768: AND value_type = 'A'

Line 3966: delete from psb_ws_line_balances_i

3962: PROCEDURE Delete_Export_Details(p_export_worksheet_type IN VARCHAR2)
3963: IS
3964: BEGIN
3965:
3966: delete from psb_ws_line_balances_i
3967: where export_id = g_export_id
3968: and export_worksheet_type = p_export_worksheet_type;
3969:
3970: delete from psb_ws_columns_i