APPS.PAY_JP_CUSTOM_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 387: l_classification_name pay_element_classifications.classification_name%type;

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;
389: l_itax_category VARCHAR2(30) := NULL;
390: l_itax_yea_category VARCHAR2(30) := NULL;
391: l_nonresident VARCHAR2(30) := NULL;

Line 413: from pay_element_classifications pec,

409: select pec.balance_initialization_flag,
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

Line 574: pay_element_classifications pec

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
578: and pec.classification_id = pet.classification_id;