eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PEL_BUS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1321: l_costable_flag pay_element_classifications.costable_flag%TYPE;

1317: p_cost_allocation_keyflex_id in number
1318: ) is
1319: --
1320: l_proc varchar2(72) := g_package || 'chk_costable_type';
1321: l_costable_flag pay_element_classifications.costable_flag%TYPE;
1322: l_uom pay_input_values_f.UOM%TYPE;
1323:
1324: l_leg_code per_business_groups.legislation_code%TYPE;
1325: l_costing_dc pay_element_classifications.costing_debit_or_credit%TYPE;

Line 1325: l_costing_dc pay_element_classifications.costing_debit_or_credit%TYPE;

1321: l_costable_flag pay_element_classifications.costable_flag%TYPE;
1322: l_uom pay_input_values_f.UOM%TYPE;
1323:
1324: l_leg_code per_business_groups.legislation_code%TYPE;
1325: l_costing_dc pay_element_classifications.costing_debit_or_credit%TYPE;
1326:
1327: l_dummy pay_element_sets.element_set_id%TYPE;
1328:
1329: cursor csr_CostableFlag is

Line 1330: select costable_flag from pay_element_classifications

1326:
1327: l_dummy pay_element_sets.element_set_id%TYPE;
1328:
1329: cursor csr_CostableFlag is
1330: select costable_flag from pay_element_classifications
1331: where classification_id in (select distinct classification_id
1332: from pay_element_types_f
1333: where element_type_id = p_element_type_id
1334: and p_effective_date between effective_start_date

Line 1347: from pay_element_classifications pec, pay_element_types_f pet,

1343:
1344:
1345: cursor csr_legcode_cr_db_type is
1346: select distinct pec.costing_debit_or_credit, pbg.legislation_code
1347: from pay_element_classifications pec, pay_element_types_f pet,
1348: per_business_groups pbg
1349: where pec.classification_id = pet.classification_id
1350: and pet.business_group_id = pbg.business_group_id (+)
1351: and pet.element_type_id = p_element_type_id;

Line 1371: pay_element_classifications class

1367: /* check the classifications of elements in the set that are specified
1368: directly by name */
1369: select 1
1370: from pay_element_type_rules rule, pay_element_types_f type,
1371: pay_element_classifications class
1372: where element_set.element_set_id = rule.element_set_id
1373: and class.classification_id = type.classification_id
1374: and type.element_type_id = rule.element_type_id
1375: and class.costing_debit_or_credit = p_costing_dc

Line 1382: pay_element_classifications class2

1378: union all
1379: /* check the element classifications specified in the set */
1380: select 1
1381: from pay_ele_classification_rules class_rule,
1382: pay_element_classifications class2
1383: where class_rule.element_set_id = element_set.element_set_id
1384: and class2.classification_id = class_rule.classification_id
1385: and class2.costing_debit_or_credit = p_costing_dc)
1386: and