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.

[Home] [Help]

APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on PQH_ELEMENT_COMMITMENTS

Line 1561: From pqh_element_commitments

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

Line 1571: l_commitment_start_date pqh_element_commitments.commitment_start_date%type;

1567: --
1568: l_prorate_start_dt date;
1569: l_prorate_end_dt date;
1570: --
1571: l_commitment_start_date pqh_element_commitments.commitment_start_date%type;
1572: l_commitment_end_date pqh_element_commitments.commitment_end_date%type;
1573: --
1574: l_prorate_amt number ;
1575: l_assign_cmmtmnt number ;

Line 1572: l_commitment_end_date pqh_element_commitments.commitment_end_date%type;

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

Line 1731: From pqh_element_commitments

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