APPS.PAY_CN_AUDIT_XMLGEN dependencies on PAY_BALANCE_TYPES

Line 526: ,PAY_BALANCE_TYPES PBT, PAY_BALANCE_TYPES_TL PBT_TL

522: 'X' exp_cat_code
523: FROM hr_organization_information hoi
524: ,hr_organization_units hou
525: ,pay_payrolls_f pap
526: ,PAY_BALANCE_TYPES PBT, PAY_BALANCE_TYPES_TL PBT_TL
527: WHERE hoi.org_information_context = 'PER_CNAO_BAL_INFO'
528: AND hou.organization_id = hoi.organization_id
529: AND hou.business_group_id = g_bg_id
530: AND pap.payroll_id = fnd_number.canonical_to_number(hoi.org_information4)

Line 934: PAY_BALANCE_TYPES PBT, PAY_BALANCE_TYPES_TL PBT_TL

930: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date
931: AND p_date_earned BETWEEN paf.effective_start_date and paf.effective_end_date) person,
932: hr_organization_information hoi,
933: hr_organization_units hou,
934: PAY_BALANCE_TYPES PBT, PAY_BALANCE_TYPES_TL PBT_TL
935: where action_context_id = p_action_context_id
936: and pai.action_information_category = 'EMPLOYEE OTHER INFORMATION'
937: and pai.action_information4 = (select nvl(h.ORG_INFORMATION7,PBT_TL.BALANCE_NAME)
938: from hr_organization_information h

Line 985: PAY_BALANCE_TYPES PBT, PAY_BALANCE_TYPES_TL PBT_TL

981: AND p_date_earned BETWEEN ppf.effective_start_date and ppf.effective_end_date
982: AND p_date_earned BETWEEN paf.effective_start_date and paf.effective_end_date) person,
983: hr_organization_information hoi,
984: hr_organization_units hou,
985: PAY_BALANCE_TYPES PBT, PAY_BALANCE_TYPES_TL PBT_TL
986: where action_context_id = p_action_context_id
987: and pai.action_information_category = 'APAC BALANCES'
988: and pai.action_information1 = nvl(PBT_TL.REPORTING_NAME,PBT_TL.BALANCE_NAME)
989: and hoi.org_information_context = 'PER_CNAO_BAL_INFO'