DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PSTA dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 1156: from pay_element_classifications pec, pay_element_types_f pat, pay_element_entries_f pet

1152: cursor csr_get_benefit_type (
1153: p_assignment_id per_all_assignments_f.assignment_id%type
1154: ) is
1155: select pat.element_type_id, pat.element_name, pat.element_information1 benefit_type_code
1156: from pay_element_classifications pec, pay_element_types_f pat, pay_element_entries_f pet
1157: where pec.classification_name = 'Benefits in Kind'
1158: and pec.legislation_code = 'FI'
1159: and (pat.legislation_code = 'FI' or pat.business_group_id = g_business_group_id)
1160: and pec.classification_id = pat.classification_id