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.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on PQH_ELEMENT_COMMITMENTS

Line 1564: From pqh_element_commitments

1560: --
1561: Cursor csr_assg_commitment is
1562: Select nvl(commitment_amount,0),
1563: commitment_start_date,commitment_end_date
1564: From pqh_element_commitments
1565: Where budget_version_id = p_budget_version_id
1566: AND assignment_id = p_assignment_id
1567: AND element_type_id = nvl(p_element_type_id,element_type_id)
1568: AND commitment_start_date <= p_period_end_date

Line 1574: l_commitment_start_date pqh_element_commitments.commitment_start_date%type;

1570: --
1571: l_prorate_start_dt date;
1572: l_prorate_end_dt date;
1573: --
1574: l_commitment_start_date pqh_element_commitments.commitment_start_date%type;
1575: l_commitment_end_date pqh_element_commitments.commitment_end_date%type;
1576: --
1577: l_prorate_amt number ;
1578: l_assign_cmmtmnt number ;

Line 1575: l_commitment_end_date pqh_element_commitments.commitment_end_date%type;

1571: l_prorate_start_dt date;
1572: l_prorate_end_dt date;
1573: --
1574: l_commitment_start_date pqh_element_commitments.commitment_start_date%type;
1575: l_commitment_end_date pqh_element_commitments.commitment_end_date%type;
1576: --
1577: l_prorate_amt number ;
1578: l_assign_cmmtmnt number ;
1579: l_amount number;

Line 1734: From pqh_element_commitments

1730: -- dates
1731: --
1732: Cursor csr_version is
1733: Select budget_version_id
1734: From pqh_element_commitments
1735: Where assignment_id = p_assignment_id
1736: AND (p_start_date <= commitment_end_date AND
1737: commitment_start_date <= p_end_date);
1738: