APPS.PAY_IN_ELEMENT_TEMPLATE_PKG dependencies on PAY_ELEMENT_TEMPLATES

Line 372: FROM pay_element_templates

368: configuration_information28,
369: configuration_information29,
370: configuration_information30,
371: object_version_number
372: FROM pay_element_templates
373: WHERE template_id = p_template_id
374: FOR UPDATE OF template_id;
375:
376: BEGIN

Line 475: l_template_id pay_element_templates.template_id%TYPE;

471: l_message VARCHAR2(1000);
472: l_effective_date CONSTANT DATE := TO_DATE('01/04/2005','DD/MM/YYYY');
473:
474: l_template_exists VARCHAR2(1);
475: l_template_id pay_element_templates.template_id%TYPE;
476: l_enabled_flag fnd_currencies.enabled_flag%TYPE;
477: l_object_version_number NUMBER ;
478: l_template_rec pay_in_etw_struct.t_template_setup_rec;
479: l_sequence NUMBER;

Line 498: FROM pay_element_templates

494:
495: BEGIN
496: SELECT 'Y', template_id
497: INTO l_template_exists, l_template_id
498: FROM pay_element_templates
499: WHERE template_type = pay_in_etw_struct.g_template_type
500: AND legislation_code = pay_in_etw_struct.g_legislation_code
501: AND template_name = p_template_name;
502: EXCEPTION

Line 565: -- PAY_ELEMENT_TEMPLATES row.

561: pay_in_utils.trace('Priority ',l_template_rec.priority);
562: END IF;
563:
564: --
565: -- PAY_ELEMENT_TEMPLATES row.
566: --
567: pay_in_utils.set_location(g_debug,l_procedure,60);
568: pay_etm_ins.ins
569: (p_template_id => l_template_rec.template_id

Line 1144: ,pay_element_templates pet

1140: WHERE ele_template_classification_id
1141: IN (SELECT petcu.ele_template_classification_id
1142: FROM pay_ele_tmplt_class_usages petcu
1143: ,pay_element_classifications pec
1144: ,pay_element_templates pet
1145: WHERE petcu.classification_id = pec.classification_id
1146: AND petcu.template_id = pet.template_id
1147: AND pet.template_name = p_template_name
1148: AND pec.classification_name = p_classification

Line 1517: ,pay_element_templates tmp

1513: ,pec.classification_name
1514: ,pet.element_name
1515: ,pet.reporting_name
1516: FROM pay_element_types_f pet
1517: ,pay_element_templates tmp
1518: ,pay_element_classifications pec
1519: WHERE pet.element_name = tmp.base_name
1520: AND tmp.template_id = p_template_id
1521: AND pet.classification_id = pec.classification_id

Line 1651: UPDATE pay_element_templates

1647: INTO l_exp_nature
1648: FROM dual;
1649: ELSE /* IN Actual Expense Allowances */
1650: IF(l_template.configuration_information2 = 'Y') THEN
1651: UPDATE pay_element_templates
1652: SET configuration_information2 = 'N'
1653: WHERE template_id = p_template_id;
1654: l_template.configuration_information2 := 'N';
1655: END IF;