APPS.PAY_JP_CUSTOM_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 421: l_classification_name pay_element_classifications.classification_name%type;

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;
423: l_itax_category VARCHAR2(30) := NULL;
424: l_itax_yea_category VARCHAR2(30) := NULL;
425: l_nonresident VARCHAR2(30) := NULL;

Line 447: from pay_element_classifications pec,

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

Line 608: pay_element_classifications pec

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