DBA Data[Home] [Help]

APPS.PAY_ELE_CLASS_RULES_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 45: from pay_element_classifications_tl ecl_tl,

41: ) return varchar2 is
42: --
43: cursor csr_classification_name is
44: select ecl_tl.classification_name
45: from pay_element_classifications_tl ecl_tl,
46: pay_element_classifications ecl
47: where ecl.classification_id = ecl_tl.classification_id
48: and ecl.classification_id = p_classification_id
49: and userenv('LANG') = ecl_tl.language;

Line 46: pay_element_classifications ecl

42: --
43: cursor csr_classification_name is
44: select ecl_tl.classification_name
45: from pay_element_classifications_tl ecl_tl,
46: pay_element_classifications ecl
47: where ecl.classification_id = ecl_tl.classification_id
48: and ecl.classification_id = p_classification_id
49: and userenv('LANG') = ecl_tl.language;
50: --

Line 51: v_classification_name pay_element_classifications.classification_name%type;

47: where ecl.classification_id = ecl_tl.classification_id
48: and ecl.classification_id = p_classification_id
49: and userenv('LANG') = ecl_tl.language;
50: --
51: v_classification_name pay_element_classifications.classification_name%type;
52: --
53: begin
54: --
55: open csr_classification_name;