APPS.PAY_FR_ARC_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 97: g_term_ele_subject_to_ss pay_element_types_f.element_Type_id%TYPE;

93: g_source_text ff_contexts.context_id%TYPE;
94: --
95: -- To hold termination element id - special processing for termination
96: --
97: g_term_ele_subject_to_ss pay_element_types_f.element_Type_id%TYPE;
98: g_term_ele_exempt_of_ss pay_element_types_f.element_Type_id%TYPE;
99: --
100: -- to hold the application_id of 'PER'
101: --

Line 98: g_term_ele_exempt_of_ss pay_element_types_f.element_Type_id%TYPE;

94: --
95: -- To hold termination element id - special processing for termination
96: --
97: g_term_ele_subject_to_ss pay_element_types_f.element_Type_id%TYPE;
98: g_term_ele_exempt_of_ss pay_element_types_f.element_Type_id%TYPE;
99: --
100: -- to hold the application_id of 'PER'
101: --
102: g_per_id fnd_application.application_id%TYPE;

Line 279: from pay_element_types_f

275: -- Get the element_type_ids of the termination elements
276: --
277: cursor csr_termination_elements (p_element_name varchar2) is
278: select element_type_id
279: from pay_element_types_f
280: where element_name = p_element_name
281: and legislation_code = 'FR';
282: --
283: cursor csr_get_dimension (p_name varchar2) is

Line 2403: ,pay_element_types_f pet

2399: 'EE',pee.source_end_date,
2400: 'RR',rr_ret.end_date) retro_pro_end
2401: from pay_run_result_values prrv
2402: ,pay_run_results prr
2403: ,pay_element_types_f pet
2404: ,pay_element_classifications pec
2405: ,pay_input_values_f_tl piv
2406: ,fnd_lookup_values user_rubric
2407: ,fnd_lookup_values seed_rubric

Line 3021: from pay_element_types_f pet

3017: ,prr.source_id Source_id
3018: ,nvl(user_rubric.tag,seed_rubric.tag) Rubric
3019: ,nvl(user_rubric.meaning,seed_rubric.meaning) Description
3020: ,base_units.meaning BASE_UNITS
3021: from pay_element_types_f pet
3022: ,pay_run_results prr
3023: ,pay_input_values_f piv
3024: ,pay_run_result_values prrv
3025: ,fnd_lookup_values user_rubric

Line 3459: , pay_element_types_f pet

3455: , pay_assignment_actions aa
3456: , pay_defined_balances db2
3457: , pay_fr_contribution_usages fcu
3458: , pay_input_values_f piv
3459: , pay_element_types_f pet
3460: where arclck.locking_action_id = p_archive_assignment_action_id
3461: and prelck.locking_action_id = arclck.locked_action_id
3462: and aa.assignment_action_id = prelck.locked_action_id
3463: and b.balance_category_id in (g_Income_Tax_Excess

Line 3578: ,pay_element_types_f pet

3574: ,ptp_date.start_date ptp_start_date
3575: ,ptp_date.end_date ptp_end_date
3576: from pay_run_result_values prrv
3577: ,pay_run_results prr
3578: ,pay_element_types_f pet
3579: ,pay_input_values_f_tl piv
3580: ,pay_payroll_actions run_payact
3581: ,pay_assignment_actions run_assact
3582: ,pay_action_interlocks arc_lock