APPS.HR_PERSON_RECORD dependencies on PAY_AC_EMP_SUM_ACTION_INFO_V

Line 2062: from pay_ac_emp_sum_action_info_v

2058: and trunc(effective_date) <= p_eff_date
2059: and tax_jurisdiction = p_state_desc) STOVERRIDE_TAX_PERCENTAGE
2060:
2061: ,(select gross_earnings
2062: from pay_ac_emp_sum_action_info_v
2063: where action_context_id = p_asg_action_id
2064: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_EARNINGS_CV
2065:
2066: ,(select (nvl(gross_earnings, 0) - nvl(pretax_deductions, 0))

Line 2067: from pay_ac_emp_sum_action_info_v

2063: where action_context_id = p_asg_action_id
2064: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_EARNINGS_CV
2065:
2066: ,(select (nvl(gross_earnings, 0) - nvl(pretax_deductions, 0))
2067: from pay_ac_emp_sum_action_info_v
2068: where action_context_id = p_asg_action_id
2069: and action_information_category = 'AC SUMMARY CURRENT') TAXABLE_GROSS_CV
2070:
2071: ,(select taxes

Line 2072: from pay_ac_emp_sum_action_info_v

2068: where action_context_id = p_asg_action_id
2069: and action_information_category = 'AC SUMMARY CURRENT') TAXABLE_GROSS_CV
2070:
2071: ,(select taxes
2072: from pay_ac_emp_sum_action_info_v
2073: where action_context_id = p_asg_action_id
2074: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_TAXES_CV
2075:
2076: ,(select (nvl(pretax_deductions, 0) + nvl(after_tax_deductions, 0))

Line 2077: from pay_ac_emp_sum_action_info_v

2073: where action_context_id = p_asg_action_id
2074: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_TAXES_CV
2075:
2076: ,(select (nvl(pretax_deductions, 0) + nvl(after_tax_deductions, 0))
2077: from pay_ac_emp_sum_action_info_v
2078: where action_context_id = p_asg_action_id
2079: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_DEDUCTIONS_CV
2080:
2081: ,(select net_pay

Line 2082: from pay_ac_emp_sum_action_info_v

2078: where action_context_id = p_asg_action_id
2079: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_DEDUCTIONS_CV
2080:
2081: ,(select net_pay
2082: from pay_ac_emp_sum_action_info_v
2083: where action_context_id = p_asg_action_id
2084: and action_information_category = 'AC SUMMARY CURRENT') NET_PAY_CV
2085:
2086: ,(select gross_earnings

Line 2087: from pay_ac_emp_sum_action_info_v

2083: where action_context_id = p_asg_action_id
2084: and action_information_category = 'AC SUMMARY CURRENT') NET_PAY_CV
2085:
2086: ,(select gross_earnings
2087: from pay_ac_emp_sum_action_info_v
2088: where action_context_id = p_asg_action_id
2089: and action_information_category = 'AC SUMMARY YTD') TOTAL_EARNINGS_YTD
2090:
2091: ,(select (nvl(gross_earnings, 0) - nvl(pretax_deductions, 0))

Line 2092: from pay_ac_emp_sum_action_info_v

2088: where action_context_id = p_asg_action_id
2089: and action_information_category = 'AC SUMMARY YTD') TOTAL_EARNINGS_YTD
2090:
2091: ,(select (nvl(gross_earnings, 0) - nvl(pretax_deductions, 0))
2092: from pay_ac_emp_sum_action_info_v
2093: where action_context_id = p_asg_action_id
2094: and action_information_category = 'AC SUMMARY YTD') TAXABLE_GROSS_YTD
2095:
2096: ,(select taxes

Line 2097: from pay_ac_emp_sum_action_info_v

2093: where action_context_id = p_asg_action_id
2094: and action_information_category = 'AC SUMMARY YTD') TAXABLE_GROSS_YTD
2095:
2096: ,(select taxes
2097: from pay_ac_emp_sum_action_info_v
2098: where action_context_id = p_asg_action_id
2099: and action_information_category = 'AC SUMMARY YTD') TOTAL_TAXES_YTD
2100:
2101: ,(select (nvl(pretax_deductions, 0) + nvl(after_tax_deductions, 0))

Line 2102: from pay_ac_emp_sum_action_info_v

2098: where action_context_id = p_asg_action_id
2099: and action_information_category = 'AC SUMMARY YTD') TOTAL_TAXES_YTD
2100:
2101: ,(select (nvl(pretax_deductions, 0) + nvl(after_tax_deductions, 0))
2102: from pay_ac_emp_sum_action_info_v
2103: where action_context_id = p_asg_action_id
2104: and action_information_category = 'AC SUMMARY YTD') TOTAL_DEDUCTIONS_YTD
2105:
2106: ,(select net_pay

Line 2107: from pay_ac_emp_sum_action_info_v

2103: where action_context_id = p_asg_action_id
2104: and action_information_category = 'AC SUMMARY YTD') TOTAL_DEDUCTIONS_YTD
2105:
2106: ,(select net_pay
2107: from pay_ac_emp_sum_action_info_v
2108: where action_context_id = p_asg_action_id
2109: and action_information_category = 'AC SUMMARY YTD') NET_PAY_YTD
2110:
2111: from pay_employee_action_info_v peai