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_BDGT_CMMTMNT_ELMNTS

Line 1091: from pqh_bdgt_cmmtmnt_elmnts

1087: RETURN NUMBER
1088: IS
1089: cursor csr_actual_exists is
1090: select 1
1091: from pqh_bdgt_cmmtmnt_elmnts
1092: where actual_commitment_type in ('ACTUAL','BOTH')
1093: and budget_id = p_budget_id;
1094:
1095: cursor curs is

Line 1097: from pqh_bdgt_cmmtmnt_elmnts

1093: and budget_id = p_budget_id;
1094:
1095: cursor curs is
1096: select element_type_id,element_input_value_id, balance_type_id
1097: from pqh_bdgt_cmmtmnt_elmnts
1098: where actual_commitment_type in ('ACTUAL','BOTH') and
1099: element_type_id = nvl(p_element_type_id,element_type_id)
1100: and budget_id = p_budget_id;
1101:

Line 4048: from pqh_bdgt_cmmtmnt_elmnts

4044: IS
4045:
4046: cursor csr_actual_exists(p_budget_id number) is
4047: select 1
4048: from pqh_bdgt_cmmtmnt_elmnts
4049: where actual_commitment_type in ('ACTUAL','BOTH')
4050: and budget_id = p_budget_id;
4051:
4052: --

Line 4073: pqh_bdgt_cmmtmnt_elmnts pbce

4069: PAY_ASSIGNMENT_ACTIONS AAC,
4070: PAY_COSTS pc,
4071: PAY_ELEMENT_TYPES_F PET,
4072: PAY_INPUT_VALUES_F INV,
4073: pqh_bdgt_cmmtmnt_elmnts pbce
4074: Where PPA.PAYROLL_ACTION_ID = AAC.PAYROLL_ACTION_ID
4075: AND PPA.PAYROLL_ID = A.PAYROLL_ID
4076: AND ppa.action_type IN ('Q','R','V','B')
4077: AND ppa.date_earned BETWEEN p_actuals_start_date AND p_actuals_end_date