APPS.PQH_COMMITMENT_PKG dependencies on PQH_BDGT_CMMTMNT_ELMNTS

Line 15: Element_type_id pqh_bdgt_cmmtmnt_elmnts.element_type_id%type,

11:
12: type cmmtmnt_dt_tab is table of cmmtmnt_dt_rec index by binary_integer;
13: --
14: type cmmtmnt_elmnts_rec is record (
15: Element_type_id pqh_bdgt_cmmtmnt_elmnts.element_type_id%type,
16: Formula_id pqh_bdgt_cmmtmnt_elmnts.formula_id%type,
17: Salary_basis_flag pqh_bdgt_cmmtmnt_elmnts.salary_basis_flag%type,
18: Element_input_value_id pqh_bdgt_cmmtmnt_elmnts.element_input_value_id%type,
19: dflt_elmnt_frequency pqh_bdgt_cmmtmnt_elmnts.dflt_elmnt_frequency%type,

Line 16: Formula_id pqh_bdgt_cmmtmnt_elmnts.formula_id%type,

12: type cmmtmnt_dt_tab is table of cmmtmnt_dt_rec index by binary_integer;
13: --
14: type cmmtmnt_elmnts_rec is record (
15: Element_type_id pqh_bdgt_cmmtmnt_elmnts.element_type_id%type,
16: Formula_id pqh_bdgt_cmmtmnt_elmnts.formula_id%type,
17: Salary_basis_flag pqh_bdgt_cmmtmnt_elmnts.salary_basis_flag%type,
18: Element_input_value_id pqh_bdgt_cmmtmnt_elmnts.element_input_value_id%type,
19: dflt_elmnt_frequency pqh_bdgt_cmmtmnt_elmnts.dflt_elmnt_frequency%type,
20: overhead_percentage pqh_bdgt_cmmtmnt_elmnts.overhead_percentage%type);

Line 17: Salary_basis_flag pqh_bdgt_cmmtmnt_elmnts.salary_basis_flag%type,

13: --
14: type cmmtmnt_elmnts_rec is record (
15: Element_type_id pqh_bdgt_cmmtmnt_elmnts.element_type_id%type,
16: Formula_id pqh_bdgt_cmmtmnt_elmnts.formula_id%type,
17: Salary_basis_flag pqh_bdgt_cmmtmnt_elmnts.salary_basis_flag%type,
18: Element_input_value_id pqh_bdgt_cmmtmnt_elmnts.element_input_value_id%type,
19: dflt_elmnt_frequency pqh_bdgt_cmmtmnt_elmnts.dflt_elmnt_frequency%type,
20: overhead_percentage pqh_bdgt_cmmtmnt_elmnts.overhead_percentage%type);
21: --

Line 18: Element_input_value_id pqh_bdgt_cmmtmnt_elmnts.element_input_value_id%type,

14: type cmmtmnt_elmnts_rec is record (
15: Element_type_id pqh_bdgt_cmmtmnt_elmnts.element_type_id%type,
16: Formula_id pqh_bdgt_cmmtmnt_elmnts.formula_id%type,
17: Salary_basis_flag pqh_bdgt_cmmtmnt_elmnts.salary_basis_flag%type,
18: Element_input_value_id pqh_bdgt_cmmtmnt_elmnts.element_input_value_id%type,
19: dflt_elmnt_frequency pqh_bdgt_cmmtmnt_elmnts.dflt_elmnt_frequency%type,
20: overhead_percentage pqh_bdgt_cmmtmnt_elmnts.overhead_percentage%type);
21: --
22: type cmmtmnt_elmnts_tab is table of cmmtmnt_elmnts_rec index by binary_integer;

Line 19: dflt_elmnt_frequency pqh_bdgt_cmmtmnt_elmnts.dflt_elmnt_frequency%type,

15: Element_type_id pqh_bdgt_cmmtmnt_elmnts.element_type_id%type,
16: Formula_id pqh_bdgt_cmmtmnt_elmnts.formula_id%type,
17: Salary_basis_flag pqh_bdgt_cmmtmnt_elmnts.salary_basis_flag%type,
18: Element_input_value_id pqh_bdgt_cmmtmnt_elmnts.element_input_value_id%type,
19: dflt_elmnt_frequency pqh_bdgt_cmmtmnt_elmnts.dflt_elmnt_frequency%type,
20: overhead_percentage pqh_bdgt_cmmtmnt_elmnts.overhead_percentage%type);
21: --
22: type cmmtmnt_elmnts_tab is table of cmmtmnt_elmnts_rec index by binary_integer;
23: --

Line 20: overhead_percentage pqh_bdgt_cmmtmnt_elmnts.overhead_percentage%type);

16: Formula_id pqh_bdgt_cmmtmnt_elmnts.formula_id%type,
17: Salary_basis_flag pqh_bdgt_cmmtmnt_elmnts.salary_basis_flag%type,
18: Element_input_value_id pqh_bdgt_cmmtmnt_elmnts.element_input_value_id%type,
19: dflt_elmnt_frequency pqh_bdgt_cmmtmnt_elmnts.dflt_elmnt_frequency%type,
20: overhead_percentage pqh_bdgt_cmmtmnt_elmnts.overhead_percentage%type);
21: --
22: type cmmtmnt_elmnts_tab is table of cmmtmnt_elmnts_rec index by binary_integer;
23: --
24: type bdgt_posn_rec is record(position_id pqh_budget_details.position_id%type);

Line 2001: From pqh_bdgt_cmmtmnt_elmnts

1997: Select Element_type_id,
1998: Formula_id,Salary_basis_flag,
1999: Element_input_value_id,
2000: dflt_elmnt_frequency,nvl(Overhead_percentage,0)
2001: From pqh_bdgt_cmmtmnt_elmnts
2002: Where budget_id = p_budget_id
2003: and actual_commitment_type in ('COMMITMENT','BOTH');
2004: --
2005: -- This cursor is used to get the budget versions if there are no elements

Line 2232: element_type_id pqh_bdgt_cmmtmnt_elmnts.element_type_id%type

2228:
2229: type element_commitment_rec is record (
2230: assignment_id per_all_assignments_f.assignment_id%type,
2231: commitment number,
2232: element_type_id pqh_bdgt_cmmtmnt_elmnts.element_type_id%type
2233: );
2234:
2235:
2236:

Line 3728: From pqh_bdgt_cmmtmnt_elmnts

3724: Select Formula_id,
3725: Salary_basis_flag,
3726: dflt_elmnt_frequency,
3727: nvl(Overhead_percentage,0)
3728: From pqh_bdgt_cmmtmnt_elmnts
3729: Where budget_id = p_budget_id
3730: and element_type_id = p_element_type_id
3731: and element_input_value_id = p_input_value_id
3732: and actual_commitment_type in ('COMMITMENT','BOTH');