APPS.PAY_JP_CUSTOM_PKG dependencies on PAY_ELEMENT_SETS

Line 385: l_element_set_name PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE;

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

Line 386: l_legislation_code pay_element_sets.legislation_code%type;

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

Line 401: from pay_element_sets pes,

397: ppa.business_group_id,
398: ppa.date_earned,
399: paa.assignment_id,
400: ppa.effective_date
401: from pay_element_sets pes,
402: pay_payroll_actions ppa,
403: pay_assignment_actions paa
404: where paa.assignment_action_id=p_assignment_action_id
405: and ppa.payroll_action_id=paa.payroll_action_id

Line 533: from pay_element_sets

529: --
530: select element_set_name,
531: legislation_code
532: into l_element_set_name, l_legislation_code
533: from pay_element_sets
534: where element_set_id = l_element_set_id;
535: --
536: if (l_element_set_name like g_name_tl.salary || '%'
537: or (l_element_set_name = 'SAL' and l_legislation_code = 'JP')) then