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 549: from pay_element_types_f

545: -- load element type info into cache
546:
547: select nvl(proration_group_id, -1), nvl(time_definition_type, 'N')
548: into l_proration_group_id, l_time_definition_type
549: from pay_element_types_f
550: where element_type_id = p_element_type_id
551: and p_date_earned between effective_start_date
552: and effective_end_date;
553:

Line 673: pay_element_types_f pet

669: l_prorate_grp_id
670: from pay_payroll_actions ppa,
671: pay_assignment_actions paa,
672: per_time_periods ptp,
673: pay_element_types_f pet
674: where paa.assignment_action_id = p_asg_act_id
675: and paa.payroll_action_id = ppa.payroll_action_id
676: and pet.element_type_id = p_et_id
677: and ppa.date_earned between pet.effective_start_date

Line 1790: pay_element_types_f pet

1786: p_eff_date date)
1787: is
1788: select prr.source_id
1789: from pay_run_results prr,
1790: pay_element_types_f pet
1791: where prr.assignment_action_id = p_aa_id
1792: and prr.source_type = 'E'
1793: and prr.element_type_id = pet.element_type_id
1794: and nvl(pet.process_mode, 'N') in ('P', 'S')

Line 2327: PAY_ELEMENT_TYPES_F pet,

2323: p_legislation in varchar2)
2324: is
2325: SELECT nvl(INCLUSION_FLAG, 'Y')
2326: FROM PAY_ELEMENT_CLASS_USAGES_F pecu,
2327: PAY_ELEMENT_TYPES_F pet,
2328: PAY_ELEMENT_CLASSIFICATIONS pec
2329: WHERE pet.element_type_id = p_element_type_id
2330: AND pet.classification_id = pecu.classification_id
2331: AND pec.classification_id = pet.classification_id

Line 2458: PROCEDURE update_prj_flag ( p_element_type_id IN pay_element_types_f.element_type_id%TYPE,

2454: --
2455: end is_element_included;
2456: --
2457: /* Bug 11708644, PAYROLL/PROJECTS INTEGRATION FOR 12.2 */
2458: PROCEDURE update_prj_flag ( p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
2459: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE ,
2460: p_flag IN VARCHAR2,
2461: p_status OUT NOCOPY varchar2
2462: ) IS

Line 2467: v_element_type_id pay_element_types_f.element_type_id%TYPE

2463: lv_proc VARCHAR2(30) := 'update_prj_flag';
2464: v_input_value_id pay_input_values_f.input_value_id%TYPE := null;
2465: --
2466: CURSOR search_input_value_id (
2467: v_element_type_id pay_element_types_f.element_type_id%TYPE
2468: ) is
2469: SELECT DISTINCT input_value_id
2470: FROM pay_input_values_f
2471: WHERE element_type_id=v_element_type_id