APPS.PAY_JP_CUSTOM_PKG dependencies on PAY_ELEMENT_SETS

Line 419: l_element_set_name PAY_ELEMENT_SETS.ELEMENT_SET_NAME%TYPE;

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

Line 420: l_legislation_code pay_element_sets.legislation_code%type;

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

Line 435: from pay_element_sets pes,

431: ppa.business_group_id,
432: ppa.date_earned,
433: paa.assignment_id,
434: ppa.effective_date
435: from pay_element_sets pes,
436: pay_payroll_actions ppa,
437: pay_assignment_actions paa
438: where paa.assignment_action_id=p_assignment_action_id
439: and ppa.payroll_action_id=paa.payroll_action_id

Line 567: from pay_element_sets

563: --
564: select element_set_name,
565: legislation_code
566: into l_element_set_name, l_legislation_code
567: from pay_element_sets
568: where element_set_id = l_element_set_id;
569: --
570: if (l_element_set_name like g_name_tl.salary || '%'
571: or (l_element_set_name = 'SAL' and l_legislation_code = 'JP')) then