APPS.PAY_CN_AUDIT_XMLGEN dependencies on PAY_ELEMENT_TYPES_F

Line 491: ,pay_element_types_f_tl petl

487: get_cost_alloc_key_flex(hoi.org_information3) exp_cat_code
488: FROM hr_organization_information hoi
489: ,hr_organization_units hou
490: ,pay_payrolls_f pap
491: ,pay_element_types_f_tl petl
492: ,pay_element_types_f pet
493: WHERE hoi.org_information_context = 'PER_CNAO_ORG_INFO'
494: AND hou.organization_id = hoi.organization_id
495: AND hou.business_group_id = g_bg_id

Line 492: ,pay_element_types_f pet

488: FROM hr_organization_information hoi
489: ,hr_organization_units hou
490: ,pay_payrolls_f pap
491: ,pay_element_types_f_tl petl
492: ,pay_element_types_f pet
493: WHERE hoi.org_information_context = 'PER_CNAO_ORG_INFO'
494: AND hou.organization_id = hoi.organization_id
495: AND hou.business_group_id = g_bg_id
496: AND pap.payroll_id = fnd_number.canonical_to_number(hoi.org_information2)

Line 892: pay_element_types_f_tl petl,

888: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date
889: AND p_date_earned BETWEEN paf.effective_start_date and paf.effective_end_date) person,
890: hr_organization_information hoi,
891: hr_organization_units hou,
892: pay_element_types_f_tl petl,
893: pay_element_types_f pet
894: where action_context_id = p_action_context_id
895: and pai.action_information_category = 'APAC ELEMENTS'
896: and pai.action_information1 = nvl(petl.reporting_name,petl.element_name)

Line 893: pay_element_types_f pet

889: AND p_date_earned BETWEEN paf.effective_start_date and paf.effective_end_date) person,
890: hr_organization_information hoi,
891: hr_organization_units hou,
892: pay_element_types_f_tl petl,
893: pay_element_types_f pet
894: where action_context_id = p_action_context_id
895: and pai.action_information_category = 'APAC ELEMENTS'
896: and pai.action_information1 = nvl(petl.reporting_name,petl.element_name)
897: and hoi.org_information_context = 'PER_CNAO_ORG_INFO'