APPS.PAY_JP_CUSTOM_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 131: yea_element pay_element_types_f.element_name%type,

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

Line 132: reyea_element pay_element_types_f.element_name%type);

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

Line 384: l_element_name pay_element_types_f.element_name%type;

380: -- l_date_earned DATE;
381: l_assignment_id NUMBER;
382: l_element_set_id number;
383: l_element_type_id number;
384: l_element_name pay_element_types_f.element_name%type;
385: l_element_set_name PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE;
386: l_legislation_code pay_element_sets.legislation_code%type;
387: l_classification_name pay_element_classifications.classification_name%type;
388: l_salary_category VARCHAR2(30) := NULL;

Line 414: pay_element_types_f pet,

410: pec.classification_name,
411: pet.element_name,
412: pec.legislation_code
413: from pay_element_classifications pec,
414: pay_element_types_f pet,
415: pay_run_results prr,
416: pay_payroll_actions ppa,
417: pay_assignment_actions paa
418: where paa.assignment_action_id=p_assignment_action_id

Line 428: pay_element_types_f pet,

424: and pec.classification_id=pet.classification_id;
425: CURSOR csr_itax_yea_category(p_assignment_action_id IN NUMBER) IS
426: select prrv.result_value
427: from pay_input_values_f piv,
428: pay_element_types_f pet,
429: pay_run_result_values prrv,
430: pay_run_results prr,
431: pay_payroll_actions ppa2,
432: pay_assignment_actions paa2,

Line 573: from pay_element_types_f pet,

569: pec.legislation_code
570: into l_element_name,
571: l_classification_name,
572: l_legislation_code
573: from pay_element_types_f pet,
574: pay_element_classifications pec
575: where pet.element_type_id = l_element_type_id
576: and l_effective_date
577: between pet.effective_start_date and pet.effective_end_date