eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJM_TRANSFER_CHARGES_PKG dependencies on DUAL

Line 824: from dual;

820: 'TERV', l_ERV_Exp_Comment,
821: 'TRV', l_Tax_Exp_Comment,
822: 'MISCELLANEOUS', l_Misc_Exp_Comment, null)
823: into l_exp_comment
824: from dual;
825:
826:
827: ----------------------------------------------------------------------
828: -- Getting Receipt Num from RCV_TRANSACTION_ID if exists

Line 970: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;

966: l_acct_burdened_cost := InvRec.Base_Charge_Amount;
967: end if;
968: else
969: l_denom_raw_cost := InvRec.Charge_Amount;
970: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;
971: if l_blue_print_enabled_flag = 'Y'
972: then
973: l_denom_burdened_cost := NULL;
974: l_acct_burdened_cost := NULL;

Line 988: into l_week_ending_day from dual;

984: into l_week_ending_day_index
985: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
986:
987: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
988: into l_week_ending_day from dual;
989:
990: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
991: into l_week_ending
992: from dual;

Line 992: from dual;

988: into l_week_ending_day from dual;
989:
990: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
991: into l_week_ending
992: from dual;
993:
994: PJM_CONC.put_line('...... Processing IPV, ERV, Tax Variances');
995:
996: -- Insert for all the charges

Line 1258: from dual;

1254: 'TRV', l_Tax_Exp_Comment,
1255: 'MISCELLANEOUS', l_Misc_Exp_Comment,
1256: 'NONREC_TAX', l_Tax_Exp_Comment,null) --bugfix 7482789
1257: into l_exp_comment
1258: from dual;
1259:
1260:
1261: ----------------------------------------------------------------------
1262: -- Getting Receipt Num from RCV_TRANSACTION_ID if exists

Line 1403: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;

1399: l_acct_burdened_cost := InvRec.Base_Charge_Amount;
1400: end if;
1401: else
1402: l_denom_raw_cost := InvRec.Charge_Amount;
1403: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;
1404: if l_blue_print_enabled_flag = 'Y'
1405: then
1406: l_denom_burdened_cost := NULL;
1407: l_acct_burdened_cost := NULL;

Line 1421: into l_week_ending_day from dual;

1417: into l_week_ending_day_index
1418: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
1419:
1420: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
1421: into l_week_ending_day from dual;
1422:
1423: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
1424: into l_week_ending
1425: from dual;

Line 1425: from dual;

1421: into l_week_ending_day from dual;
1422:
1423: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
1424: into l_week_ending
1425: from dual;
1426:
1427: PJM_CONC.put_line('...... Processing Special Charge');
1428:
1429: -- Insert for all the charges

Line 1698: from dual;

1694: 'TERV', l_Tax_Exp_Comment,
1695: 'TRV', l_Tax_Exp_Comment,
1696: 'MISCELLANEOUS', l_Misc_Exp_Comment, null)
1697: into l_exp_comment
1698: from dual;
1699:
1700: ----------------------------------------------------------------------
1701: -- Getting Receipt Num from RCV_TRANSACTION_ID if exists
1702: ----------------------------------------------------------------------

Line 1843: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;

1839: l_acct_burdened_cost := InvRec.Base_Charge_Amount;
1840: end if;
1841: else
1842: l_denom_raw_cost := InvRec.Charge_Amount;
1843: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;
1844: if l_blue_print_enabled_flag = 'Y'
1845: then
1846: l_denom_burdened_cost := NULL;
1847: l_acct_burdened_cost := NULL;

Line 1861: into l_week_ending_day from dual;

1857: into l_week_ending_day_index
1858: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
1859:
1860: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
1861: into l_week_ending_day from dual;
1862:
1863: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
1864: into l_week_ending
1865: from dual;

Line 1865: from dual;

1861: into l_week_ending_day from dual;
1862:
1863: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
1864: into l_week_ending
1865: from dual;
1866:
1867: PJM_CONC.put_line('...... Processing IPV, ERV, Tax Variances');
1868:
1869: -- Insert for Charges

Line 2126: from dual;

2122: 'TRV', l_Tax_Exp_Comment,
2123: 'MISCELLANEOUS', l_Misc_Exp_Comment,
2124: 'NONREC_TAX', l_Tax_Exp_Comment,null) --bugfix 7482789
2125: into l_exp_comment
2126: from dual;
2127:
2128: ----------------------------------------------------------------------
2129: -- Getting Receipt Num from RCV_TRANSACTION_ID if exists
2130: ----------------------------------------------------------------------

Line 2272: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;

2268: l_acct_burdened_cost := InvRec.Base_Charge_Amount;
2269: end if;
2270: else
2271: l_denom_raw_cost := InvRec.Charge_Amount;
2272: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;
2273: if l_blue_print_enabled_flag = 'Y'
2274: then
2275: l_denom_burdened_cost := NULL;
2276: l_acct_burdened_cost := NULL;

Line 2290: into l_week_ending_day from dual;

2286: into l_week_ending_day_index
2287: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
2288:
2289: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
2290: into l_week_ending_day from dual;
2291:
2292: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
2293: into l_week_ending
2294: from dual;

Line 2294: from dual;

2290: into l_week_ending_day from dual;
2291:
2292: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
2293: into l_week_ending
2294: from dual;
2295:
2296: PJM_CONC.put_line('...... Processing Special Charges');
2297:
2298: -- Insert for Charges