DBA Data[Home] [Help]

APPS.PAY_SE_EXPIRY_SUPPORT dependencies on PAY_BALANCE_DIMENSIONS

Line 33: ,pay_balance_dimensions bd

29: SELECT bd.period_type
30: ,pact.business_group_id
31: FROM pay_payroll_actions pact
32: ,hr_organization_information hoi
33: ,pay_balance_dimensions bd
34: WHERE pact.payroll_action_id = p_payroll_action_id
35: AND hoi.organization_id = pact.business_group_id
36: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
37: AND bd.dimension_name = p_dimension_name

Line 109: ,pay_balance_dimensions bd

105: SELECT bd.period_type
106: ,pact.business_group_id
107: FROM pay_payroll_actions pact
108: ,hr_organization_information hoi
109: ,pay_balance_dimensions bd
110: WHERE pact.payroll_action_id = p_payroll_action_id
111: AND hoi.organization_id = pact.business_group_id
112: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
113: AND bd.dimension_name = p_dimension_name