APPS.HR_GENERATE_PRETAX dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 3577: pay_element_classifications pec,

3573:
3574: CURSOR get_pretax_bals IS
3575: SELECT pbc.balance_type_id
3576: FROM pay_balance_classifications pbc,
3577: pay_element_classifications pec,
3578: pay_balance_types pbt
3579: WHERE nvl(pbc.business_group_id, p_busgrp_id) = p_busgrp_id
3580: AND nvl(pbc.legislation_code, 'US') = 'US'
3581: AND pbc.classification_id = pec.classification_id

Line 3957: from pay_element_classifications

3953: begin
3954:
3955: select distinct(classification_id)
3956: into v_primary_class_id
3957: from pay_element_classifications
3958: where upper(classification_name) = upper(p_ele_classification)
3959: and business_group_id is null
3960: and legislation_code = 'US';
3961:

Line 3978: FROM pay_element_classifications

3974: SELECT default_low_priority,
3975: default_high_priority
3976: INTO v_class_lo_priority,
3977: v_class_hi_priority
3978: FROM pay_element_classifications
3979: WHERE classification_id = v_primary_class_id
3980: AND business_group_id is null
3981: AND legislation_code = 'US';
3982:

Line 3993: from pay_element_classifications

3989:
3990: -- Find default priority for Involuntary Deductions classification
3991: select default_high_priority
3992: into l_invol_dflt_prio
3993: from pay_element_classifications
3994: where UPPER(classification_name) = UPPER(g_invol_class_name)
3995: and business_group_id is null
3996: and legislation_code = 'US';
3997:

Line 4088: from pay_element_classifications

4084: hr_utility.set_location('hr_generate_pretax.ins_deduction_template',55);
4085:
4086: select default_priority
4087: into v_emp_liab_dflt_prio
4088: from pay_element_classifications
4089: where classification_name = 'Employer Liabilities'
4090: /* added check for legislation_code BUG 912994 */
4091: and legislation_code = g_template_leg_code;
4092: