APPS.PAY_CORE_UTILS dependencies on PAY_ELEMENT_TYPES_F

Line 59: type t_proration_group_id is table of pay_element_types_f.proration_group_id%type

55: g_leg_context_iv_rec t_leg_context_iv_rec;
56: --
57: -- Caches for get_entry_end_date
58: --
59: type t_proration_group_id is table of pay_element_types_f.proration_group_id%type
60: index by binary_integer;
61: type t_payroll_action_id is table of pay_payroll_actions.payroll_action_id%type
62: index by binary_integer;
63: type t_date is table of date

Line 457: from pay_element_types_f

453: -- load element type info into cache
454:
455: select nvl(proration_group_id, -1), nvl(time_definition_type, 'N')
456: into l_proration_group_id, l_time_definition_type
457: from pay_element_types_f
458: where element_type_id = p_element_type_id
459: and p_date_earned between effective_start_date
460: and effective_end_date;
461:

Line 581: pay_element_types_f pet

577: l_prorate_grp_id
578: from pay_payroll_actions ppa,
579: pay_assignment_actions paa,
580: per_time_periods ptp,
581: pay_element_types_f pet
582: where paa.assignment_action_id = p_asg_act_id
583: and paa.payroll_action_id = ppa.payroll_action_id
584: and pet.element_type_id = p_et_id
585: and ppa.date_earned between pet.effective_start_date

Line 1677: pay_element_types_f pet

1673: p_eff_date date)
1674: is
1675: select prr.source_id
1676: from pay_run_results prr,
1677: pay_element_types_f pet
1678: where prr.assignment_action_id = p_aa_id
1679: and prr.source_type = 'E'
1680: and prr.element_type_id = pet.element_type_id
1681: and nvl(pet.process_mode, 'N') in ('P', 'S')

Line 2206: PAY_ELEMENT_TYPES_F pet,

2202: p_legislation in varchar2)
2203: is
2204: SELECT nvl(INCLUSION_FLAG, 'Y')
2205: FROM PAY_ELEMENT_CLASS_USAGES_F pecu,
2206: PAY_ELEMENT_TYPES_F pet,
2207: PAY_ELEMENT_CLASSIFICATIONS pec
2208: WHERE pet.element_type_id = p_element_type_id
2209: AND pet.classification_id = pecu.classification_id
2210: AND pec.classification_id = pet.classification_id