APPS.PAY_JP_CUSTOM_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 133: yea_element pay_element_types_f.element_name%type,

129: yea_category2 VARCHAR2(80),
130: non_res VARCHAR2(80),
131: non_res_date VARCHAR2(80),
132: res_date VARCHAR2(80),
133: yea_element pay_element_types_f.element_name%type,
134: reyea_element pay_element_types_f.element_name%type);
135: g_itax itax_rec;
136: g_iv iv_rec;
137: g_bal bal_rec;

Line 134: reyea_element pay_element_types_f.element_name%type);

130: non_res VARCHAR2(80),
131: non_res_date VARCHAR2(80),
132: res_date VARCHAR2(80),
133: yea_element pay_element_types_f.element_name%type,
134: reyea_element pay_element_types_f.element_name%type);
135: g_itax itax_rec;
136: g_iv iv_rec;
137: g_bal bal_rec;
138: g_name_tl name_tl;

Line 418: l_element_name pay_element_types_f.element_name%type;

414: -- l_date_earned DATE;
415: l_assignment_id NUMBER;
416: l_element_set_id number;
417: l_element_type_id number;
418: l_element_name pay_element_types_f.element_name%type;
419: l_element_set_name PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE;
420: l_legislation_code pay_element_sets.legislation_code%type;
421: l_classification_name pay_element_classifications.classification_name%type;
422: l_salary_category VARCHAR2(30) := NULL;

Line 448: pay_element_types_f pet,

444: pec.classification_name,
445: pet.element_name,
446: pec.legislation_code
447: from pay_element_classifications pec,
448: pay_element_types_f pet,
449: pay_run_results prr,
450: pay_payroll_actions ppa,
451: pay_assignment_actions paa
452: where paa.assignment_action_id=p_assignment_action_id

Line 462: pay_element_types_f pet,

458: and pec.classification_id=pet.classification_id;
459: CURSOR csr_itax_yea_category(p_assignment_action_id IN NUMBER) IS
460: select prrv.result_value
461: from pay_input_values_f piv,
462: pay_element_types_f pet,
463: pay_run_result_values prrv,
464: pay_run_results prr,
465: pay_payroll_actions ppa2,
466: pay_assignment_actions paa2,

Line 607: from pay_element_types_f pet,

603: pec.legislation_code
604: into l_element_name,
605: l_classification_name,
606: l_legislation_code
607: from pay_element_types_f pet,
608: pay_element_classifications pec
609: where pet.element_type_id = l_element_type_id
610: and l_effective_date
611: between pet.effective_start_date and pet.effective_end_date