APPS.PAY_FI_EXPIRY_SUPPORT dependencies on PAY_BALANCE_DIMENSIONS

Line 119: ,pay_balance_dimensions bd

115: SELECT bd.period_type
116: ,pact.business_group_id
117: FROM pay_payroll_actions pact
118: ,hr_organization_information hoi
119: ,pay_balance_dimensions bd
120: WHERE pact.payroll_action_id = p_payroll_action_id
121: AND hoi.organization_id = pact.business_group_id
122: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
123: AND bd.dimension_name = p_dimension_name

Line 254: ,pay_balance_dimensions bd

250: SELECT bd.period_type
251: ,pact.business_group_id
252: FROM pay_payroll_actions pact
253: ,hr_organization_information hoi
254: ,pay_balance_dimensions bd
255: WHERE pact.payroll_action_id = p_payroll_action_id
256: AND hoi.organization_id = pact.business_group_id
257: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
258: AND bd.dimension_name = p_dimension_name

Line 367: ,pay_balance_dimensions bd

363: SELECT bd.period_type
364: ,pact.business_group_id
365: FROM pay_payroll_actions pact
366: ,hr_organization_information hoi
367: ,pay_balance_dimensions bd
368: WHERE pact.payroll_action_id = p_payroll_action_id
369: AND hoi.organization_id = pact.business_group_id
370: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
371: AND bd.dimension_name = p_dimension_name

Line 450: ,pay_balance_dimensions bd

446: SELECT bd.period_type
447: ,pact.business_group_id
448: FROM pay_payroll_actions pact
449: ,hr_organization_information hoi
450: ,pay_balance_dimensions bd
451: WHERE pact.payroll_action_id = p_payroll_action_id
452: AND hoi.organization_id = pact.business_group_id
453: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
454: AND bd.dimension_name = p_dimension_name