APPS.PAY_US_TAX_BALS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 407: pay_assignment_actions paa,

403: from dual
404: where exists (
405: select ''
406: from pay_payroll_actions ppa,
407: pay_assignment_actions paa,
408: pay_assignment_latest_balances palb
409: where palb.assignment_id = p_assignment_id
410: and palb.defined_balance_id = l_defined_balance_id
411: and palb.assignment_action_id =

Line 886: from pay_assignment_actions

882: -- doing group function (min)
883: --
884: CURSOR get_pay_action_id IS
885: select assignment_action_id
886: from pay_assignment_actions
887: where payroll_action_id = p_payroll_action_id;
888:
889: /* we need to get the max assignment_action_id for the core
890: balance package. from the max aaid they find the business group

Line 896: from pay_assignment_actions paa,pay_payroll_actions ppa

892:
893: /*
894: CURSOR c_get_min_aaid(p_start_date date , p_end_date date) is
895: select nvl(min(assignment_action_id),-1)
896: from pay_assignment_actions paa,pay_payroll_actions ppa
897: where paa.tax_unit_id = p_gre_id_context
898: and ppa.payroll_action_id = paa.payroll_action_id
899: and ppa.effective_date between p_start_date and p_end_date
900: and ppa.action_type in ('R','Q','I','B','V') ;

Line 905: from pay_assignment_actions paa,pay_payroll_actions ppa,pay_payrolls_f ppf

901: */
902:
903: CURSOR c_get_min_aaid(p_start_date date , p_end_date date,p_bg_id number) is
904: select nvl(min(assignment_action_id),-1)
905: from pay_assignment_actions paa,pay_payroll_actions ppa,pay_payrolls_f ppf
906: where ppa.business_group_id +0 = p_bg_id
907: and ppa.payroll_action_id = paa.payroll_action_id
908: and ppa.effective_date between p_start_date and p_end_date
909: and ppa.action_type in ('R','Q','I','B','V')

Line 1299: from pay_assignment_actions paa,

1295: begin
1296: /* Modified query for performance enhancement (Bug 3343974). */
1297: select min(paa.assignment_id)
1298: into l_assignment_id
1299: from pay_assignment_actions paa,
1300: pay_payroll_actions pact,
1301: pay_payrolls_f ppf
1302: where pact.effective_date <= l_virtual_date
1303: and pact.payroll_action_id=paa.payroll_action_id

Line 2070: 'from pay_assignment_actions PAA, ' ||

2066: g_dim_tbl_grp(0) := 'GRE_QTD';
2067: g_dim_tbl_asg(0) := 'ASG_GRE_QTD';
2068: g_dim_tbl_jdr(0) := 'N';
2069: g_dim_tbl_crs(0) := 'select distinct PAA.assignment_id ' ||
2070: 'from pay_assignment_actions PAA, ' ||
2071: ' pay_payroll_actions PPA ' ||
2072: 'where PAA.tax_unit_id = :TAX_UNIT_ID ' ||
2073: 'and PPA.payroll_action_id = ' ||
2074: ' PAA.payroll_action_id ' ||

Line 2095: 'from pay_assignment_actions PAA, ' ||

2091: g_dim_tbl_grp(1) := 'GRE_YTD';
2092: g_dim_tbl_asg(1) := 'ASG_GRE_YTD';
2093: g_dim_tbl_jdr(1) := 'N';
2094: g_dim_tbl_crs(1) := 'select distinct PAA.assignment_id ' ||
2095: 'from pay_assignment_actions PAA, ' ||
2096: ' pay_payroll_actions PPA ' ||
2097: 'where PAA.tax_unit_id = :TAX_UNIT_ID ' ||
2098: 'and PPA.payroll_action_id = ' ||
2099: ' PAA.payroll_action_id ' ||

Line 2120: 'from pay_assignment_actions PAA, ' ||

2116: g_dim_tbl_grp(2) := 'SUBJECT_TO_TAX_GRE_YTD';
2117: g_dim_tbl_asg(2) := 'SUBJECT_TO_TAX_ASG_GRE_YTD';
2118: g_dim_tbl_jdr(2) := 'N';
2119: g_dim_tbl_crs(2) := 'select distinct PAA.assignment_id ' ||
2120: 'from pay_assignment_actions PAA, ' ||
2121: ' pay_payroll_actions PPA ' ||
2122: 'where PAA.tax_unit_id = :TAX_UNIT_ID ' ||
2123: 'and PPA.payroll_action_id = ' ||
2124: ' PAA.payroll_action_id ' ||

Line 2156: ' pay_assignment_actions PAA ' ||

2152: 'substr(:JURISDICTION_CODE, 1, ' ||
2153: 'PBT.jurisdiction_level) ' ||
2154: 'and exists (select 1 ' ||
2155: ' from pay_payroll_actions PPA, ' ||
2156: ' pay_assignment_actions PAA ' ||
2157: ' where PAA.assignment_id = ' ||
2158: 'PAR.assignment_id ' ||
2159: ' and PAA.tax_unit_id = ' ||
2160: 'PAR.tax_unit_id ' ||