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 752: from dual;

748: 'TERV', l_ERV_Exp_Comment,
749: 'TRV', l_Tax_Exp_Comment,
750: 'MISCELLANEOUS', l_Misc_Exp_Comment, null)
751: into l_exp_comment
752: from dual;
753:
754:
755: ----------------------------------------------------------------------
756: -- Getting Receipt Num from RCV_TRANSACTION_ID if exists

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

889: l_acct_burdened_cost := InvRec.Base_Charge_Amount;
890: end if;
891: else
892: l_denom_raw_cost := InvRec.Charge_Amount;
893: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;
894: if l_blue_print_enabled_flag = 'Y'
895: then
896: l_denom_burdened_cost := NULL;
897: l_acct_burdened_cost := NULL;

Line 911: into l_week_ending_day from dual;

907: into l_week_ending_day_index
908: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
909:
910: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
911: into l_week_ending_day from dual;
912:
913: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
914: into l_week_ending
915: from dual;

Line 915: from dual;

911: into l_week_ending_day from dual;
912:
913: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
914: into l_week_ending
915: from dual;
916:
917: PJM_CONC.put_line('...... Processing IPV, ERV, Tax Variances');
918:
919: -- Insert for all the charges

Line 1120: from dual;

1116: 'TRV', l_Tax_Exp_Comment,
1117: 'MISCELLANEOUS', l_Misc_Exp_Comment,
1118: 'NONREC_TAX', l_Tax_Exp_Comment,null) --bugfix 7482789
1119: into l_exp_comment
1120: from dual;
1121:
1122:
1123: ----------------------------------------------------------------------
1124: -- Getting Receipt Num from RCV_TRANSACTION_ID if exists

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

1257: l_acct_burdened_cost := InvRec.Base_Charge_Amount;
1258: end if;
1259: else
1260: l_denom_raw_cost := InvRec.Charge_Amount;
1261: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;
1262: if l_blue_print_enabled_flag = 'Y'
1263: then
1264: l_denom_burdened_cost := NULL;
1265: l_acct_burdened_cost := NULL;

Line 1279: into l_week_ending_day from dual;

1275: into l_week_ending_day_index
1276: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
1277:
1278: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
1279: into l_week_ending_day from dual;
1280:
1281: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
1282: into l_week_ending
1283: from dual;

Line 1283: from dual;

1279: into l_week_ending_day from dual;
1280:
1281: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
1282: into l_week_ending
1283: from dual;
1284:
1285: PJM_CONC.put_line('...... Processing Special Charge');
1286:
1287: -- Insert for all the charges

Line 1496: from dual;

1492: 'TERV', l_Tax_Exp_Comment,
1493: 'TRV', l_Tax_Exp_Comment,
1494: 'MISCELLANEOUS', l_Misc_Exp_Comment, null)
1495: into l_exp_comment
1496: from dual;
1497:
1498: ----------------------------------------------------------------------
1499: -- Getting Receipt Num from RCV_TRANSACTION_ID if exists
1500: ----------------------------------------------------------------------

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

1632: l_acct_burdened_cost := InvRec.Base_Charge_Amount;
1633: end if;
1634: else
1635: l_denom_raw_cost := InvRec.Charge_Amount;
1636: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;
1637: if l_blue_print_enabled_flag = 'Y'
1638: then
1639: l_denom_burdened_cost := NULL;
1640: l_acct_burdened_cost := NULL;

Line 1654: into l_week_ending_day from dual;

1650: into l_week_ending_day_index
1651: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
1652:
1653: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
1654: into l_week_ending_day from dual;
1655:
1656: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
1657: into l_week_ending
1658: from dual;

Line 1658: from dual;

1654: into l_week_ending_day from dual;
1655:
1656: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
1657: into l_week_ending
1658: from dual;
1659:
1660: PJM_CONC.put_line('...... Processing IPV, ERV, Tax Variances');
1661:
1662: -- Insert for Charges

Line 1861: from dual;

1857: 'TRV', l_Tax_Exp_Comment,
1858: 'MISCELLANEOUS', l_Misc_Exp_Comment,
1859: 'NONREC_TAX', l_Tax_Exp_Comment,null) --bugfix 7482789
1860: into l_exp_comment
1861: from dual;
1862:
1863: ----------------------------------------------------------------------
1864: -- Getting Receipt Num from RCV_TRANSACTION_ID if exists
1865: ----------------------------------------------------------------------

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

1997: l_acct_burdened_cost := InvRec.Base_Charge_Amount;
1998: end if;
1999: else
2000: l_denom_raw_cost := InvRec.Charge_Amount;
2001: select nvl(InvRec.Base_Charge_Amount, InvRec.Charge_Amount) into l_acct_raw_cost from dual;
2002: if l_blue_print_enabled_flag = 'Y'
2003: then
2004: l_denom_burdened_cost := NULL;
2005: l_acct_burdened_cost := NULL;

Line 2019: into l_week_ending_day from dual;

2015: into l_week_ending_day_index
2016: FROM pa_implementations_all WHERE org_id = InvRec.Proj_Org_Id;
2017:
2018: select to_char(to_date('01-01-1950','DD-MM-YYYY') + l_week_ending_day_index - 1, 'Day')
2019: into l_week_ending_day from dual;
2020:
2021: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
2022: into l_week_ending
2023: from dual;

Line 2023: from dual;

2019: into l_week_ending_day from dual;
2020:
2021: select next_day( trunc(InvRec.Expenditure_Item_Date)-1, l_week_ending_day )
2022: into l_week_ending
2023: from dual;
2024:
2025: PJM_CONC.put_line('...... Processing Special Charges');
2026:
2027: -- Insert for Charges