APPS.PQH_COMMITMENT_PKG dependencies on PER_PAY_BASES

Line 1575: from per_pay_bases ppb

1571: and piv.effective_start_date <= p_commit_calculation_end_dt ;
1572: -- This cursor gets the pay basis frequency for a particular assignment.
1573: Cursor csr_get_pay_basis_freq (p_pay_basis_id in number) is
1574: select pay_basis
1575: from per_pay_bases ppb
1576: where ppb.pay_basis_id = p_pay_basis_id;
1577:
1578: -- select pay_basis from per_pay_bases ppb, per_all_assignments_f paf
1579: -- where paf.pay_basis_id = ppb.pay_basis_id

Line 1578: -- select pay_basis from per_pay_bases ppb, per_all_assignments_f paf

1574: select pay_basis
1575: from per_pay_bases ppb
1576: where ppb.pay_basis_id = p_pay_basis_id;
1577:
1578: -- select pay_basis from per_pay_bases ppb, per_all_assignments_f paf
1579: -- where paf.pay_basis_id = ppb.pay_basis_id
1580: -- and paf.assignment_id = p_assignment_id
1581: --and p_commit_calculation_dt between paf.effective_start_date and paf.effective_end_date;
1582: -- and paf.effective_end_date >= p_commit_calculation_dt

Line 1768: l_pay_basis per_pay_bases.pay_basis%type;

1764: --
1765: -- DECLARE all local variables.
1766: --
1767: l_entry_value number;
1768: l_pay_basis per_pay_bases.pay_basis%type;
1769: l_adjusted_start_dt pqh_element_commitments.commitment_start_date%type;
1770: l_adjusted_end_dt pqh_element_commitments.commitment_end_date%type;
1771: --
1772: --

Line 1785: from per_pay_bases ppb

1781: cursor csr_pay_basis (p_pay_basis_id in number,
1782: p_commit_calculation_dt in date,
1783: p_commit_calculation_end_dt in date) is
1784: Select ppb.pay_basis,ppb.input_value_id
1785: from per_pay_bases ppb
1786: , pay_input_values_f piv --To ensure that this input value id belongs to the passed element_type
1787: where ppb.pay_basis_id = p_pay_basis_id
1788: and piv.input_value_id = ppb.input_value_id
1789: and piv.element_type_id = p_element_type_id

Line 3744: from per_pay_bases ppb

3740: And p_effective_date between effective_start_date
3741: AND effective_end_date;
3742: Cursor csr_salary_basis(p_pay_basis_id number) is
3743: Select ppb.input_value_id
3744: from per_pay_bases ppb
3745: , pay_input_values_f piv --To ensure that this input value id belongs to the passed element_type
3746: where ppb.pay_basis_id = p_pay_basis_id
3747: and piv.input_value_id = ppb.input_value_id
3748: and piv.element_type_id = p_element_type_id