eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 124: g_tax_unit_id pay_assignment_actions.tax_unit_id%type;

120: g_debug boolean ;
121: g_package constant varchar2(60) := 'pay_au_rec_det_paysum_mode.'; -- Global to store package name for tracing.
122: g_end_date date;
123: g_start_date date;
124: g_tax_unit_id pay_assignment_actions.tax_unit_id%type;
125: g_attribute_id pay_balance_attributes.attribute_id%type; -- bug 7571101
126: g_taxable_etp number; /* Start 9226023 - Global varaibles to store Taxable and Tax Free portions of ETP */
127: g_tax_free_etp number; /* End 9226023 */
128:

Line 785: ,c_legal_employer pay_assignment_actions.tax_unit_id%type

781: ,c_start_person per_all_people_f.person_id%type
782: ,c_end_person per_all_people_f.person_id%type
783: ,c_employee_type per_all_people_f.current_employee_flag%type
784: ,c_business_group_id hr_all_organization_units.organization_id%type
785: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
786: ,c_payroll_id varchar2
787: ,c_fin_year_start date
788: ,c_fin_year_end date
789: ,c_lst_fbt_yr_start date

Line 826: ,pay_assignment_actions rpac

822: and paa.payroll_id like c_payroll_id
823: and paa.assignment_id like c_assignment_id
824: AND EXISTS (SELECT /*+ ORDERED */''
825: FROM per_assignments_f paaf
826: ,pay_assignment_actions rpac
827: ,pay_payroll_actions rppa
828: WHERE rppa.effective_date between c_fin_year_start AND c_fin_year_end /*Bug3048962 */
829: AND rppa.action_type in ('R','Q','B','I')
830: AND rpac.tax_unit_id = c_legal_employer

Line 840: ,pay_assignment_actions rpac

836: AND rppa.effective_date between paaf.effective_start_date AND paaf.effective_end_date
837: UNION
838: SELECT /*+ ORDERED */''
839: FROM per_assignments_f paaf
840: ,pay_assignment_actions rpac
841: ,pay_payroll_actions rppa
842: WHERE pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
843: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end
844: AND pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id

Line 868: ,c_legal_employer pay_assignment_actions.tax_unit_id%type

864: ,c_start_person per_all_people_f.person_id%type
865: ,c_end_person per_all_people_f.person_id%type
866: ,c_employee_type per_all_people_f.current_employee_flag%type
867: ,c_business_group_id hr_all_organization_units.organization_id%type
868: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
869: ,c_payroll_id varchar2
870: ,c_fin_year_start date
871: ,c_fin_year_end date
872: ,c_lst_fbt_yr_start date

Line 909: ,pay_assignment_actions rpac

905: and paa.payroll_id like c_payroll_id
906: and paa.assignment_id = c_assignment_id
907: AND EXISTS (SELECT /*+ ORDERED */''
908: FROM per_assignments_f paaf
909: ,pay_assignment_actions rpac
910: ,pay_payroll_actions rppa
911: WHERE rppa.effective_date between c_fin_year_start AND c_fin_year_end /*Bug3048962 */
912: AND rppa.action_type in ('R','Q','B','I')
913: AND rpac.tax_unit_id = c_legal_employer

Line 923: ,pay_assignment_actions rpac

919: AND rppa.effective_date between paaf.effective_start_date AND paaf.effective_end_date
920: UNION
921: SELECT /*+ ORDERED */''
922: FROM per_assignments_f paaf
923: ,pay_assignment_actions rpac
924: ,pay_payroll_actions rppa
925: WHERE pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
926: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end
927: AND pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id

Line 954: ,c_legal_employer pay_assignment_actions.tax_unit_id%type

950: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
951: ,c_chunk NUMBER
952: ,c_employee_type per_all_people_f.current_employee_flag%type
953: ,c_business_group_id hr_all_organization_units.organization_id%type
954: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
955: ,c_payroll_id varchar2
956: ,c_fin_year_start date
957: ,c_fin_year_end date
958: ,c_lst_fbt_yr_start date

Line 996: ,pay_assignment_actions rpac

992: AND paa.payroll_id like c_payroll_id
993: AND paa.assignment_id like c_assignment_id
994: AND EXISTS (SELECT /*+ ORDERED */''
995: FROM per_assignments_f paaf
996: ,pay_assignment_actions rpac
997: ,pay_payroll_actions rppa
998: WHERE rppa.effective_date between c_fin_year_start AND c_fin_year_end /*Bug3048962 */
999: AND rppa.action_type in ('R','Q','B','I')
1000: AND rpac.tax_unit_id = c_legal_employer

Line 1010: ,pay_assignment_actions rpac

1006: AND rppa.effective_date between paaf.effective_start_date AND paaf.effective_end_date
1007: UNION
1008: SELECT /*+ ORDERED */''
1009: FROM per_assignments_f paaf
1010: ,pay_assignment_actions rpac
1011: ,pay_payroll_actions rppa
1012: WHERE pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
1013: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end
1014: AND pay_balance_pkg.get_value(c_fbt_defined_balance_id, rpac.assignment_action_id

Line 1040: select pay_assignment_actions_s.nextval

1036: and pbd.legislation_code = pbt.legislation_code
1037: and pbd.legislation_code = pdb.legislation_code;
1038:
1039: cursor csr_next_action_id is
1040: select pay_assignment_actions_s.nextval
1041: from dual;
1042:
1043: /* Bug 5708255 */
1044: -------------------------------------------

Line 1057: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;

1053: AND c_year_end BETWEEN effective_start_date
1054: AND effective_end_date ;
1055:
1056:
1057: l_next_assignment_action_id pay_assignment_actions.assignment_action_id%type;
1058: l_procedure varchar2(200) ;
1059: i number;
1060:
1061: l_lst_yr_start date;

Line 1263: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

1259: -- fetches appropriate Balance values using BBR.
1260: --------------------------------------------------------------------+
1261:
1262: procedure archive_code
1263: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1264: ,p_effective_date in pay_payroll_actions.effective_date%type
1265: )
1266: is
1267:

Line 1301: pay_assignment_actions paa1

1297: per_pay_bases ppb,
1298: per_pay_proposals pro,
1299: per_assignment_status_types past,
1300: hr_all_organization_units hou,
1301: pay_assignment_actions paa1
1302: ,hr_soft_coding_keyflex hsc
1303: ,hr_all_organization_units hou1
1304: -- ,pay_payrolls_f papf /*Bug 4688800*/
1305: where pap.person_id = paa.person_id

Line 1377: pay_assignment_actions paa

1373: pps.actual_termination_date
1374: from per_people_f pap,
1375: per_assignments_f paf,
1376: per_periods_of_service pps,
1377: pay_assignment_actions paa
1378: where pap.person_id = paf.person_id
1379: and paf.assignment_id = paa.assignment_id
1380: and pps.person_id = pap.person_id
1381: and pps.period_of_service_id = paf.period_of_service_id

Line 1403: from pay_assignment_actions paa

1399: ,c_tax_unit_id varchar2)
1400: is
1401: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1402: ,max(paa.action_sequence) action_sequence
1403: from pay_assignment_actions paa
1404: , pay_payroll_actions ppa
1405: , per_assignments_f paf
1406: where paa.assignment_id = paf.assignment_id
1407: and paf.assignment_id = c_assignment_id

Line 1426: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE)

1422: --------------------------------------------------------------------+
1423:
1424: cursor c_payment_summary_details(c_assignment_id number,
1425: c_fin_date date,
1426: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE)
1427: is
1428: select hr.meaning fin_year
1429: from per_assignment_extra_info pae,
1430: hr_lookups hr

Line 2181: procedure get_fbt_balance(p_assignment_id in pay_assignment_actions.assignment_id%type

2177: -- and Medicare Levy
2178: --------------------------------------------------------------------+
2179:
2180:
2181: procedure get_fbt_balance(p_assignment_id in pay_assignment_actions.assignment_id%type
2182: ,p_start_date in date
2183: ,p_end_date in date
2184: ,p_action_sequence out nocopy number)
2185: is

Line 2187: c_assignment_id pay_assignment_actions.assignment_id%TYPE,

2183: ,p_end_date in date
2184: ,p_action_sequence out nocopy number)
2185: is
2186: cursor c_max_assignment_action_id(
2187: c_assignment_id pay_assignment_actions.assignment_id%TYPE,
2188: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
2189: c_start_date date,
2190: c_end_date date)
2191: IS

Line 2188: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,

2184: ,p_action_sequence out nocopy number)
2185: is
2186: cursor c_max_assignment_action_id(
2187: c_assignment_id pay_assignment_actions.assignment_id%TYPE,
2188: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
2189: c_start_date date,
2190: c_end_date date)
2191: IS
2192: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id

Line 2194: from pay_assignment_actions paa

2190: c_end_date date)
2191: IS
2192: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
2193: ,max(paa.action_sequence) action_sequence
2194: from pay_assignment_actions paa
2195: , pay_payroll_actions ppa
2196: , per_assignments_f paf
2197: where paa.assignment_id = paf.assignment_id
2198: and paf.assignment_id = c_assignment_id

Line 2220: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;

2216: AND effective_end_date ;
2217:
2218: r_global c_get_global%ROWTYPE;
2219: l_bal_value number;
2220: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2221: l_max_action_sequence pay_assignment_actions.action_sequence%type;
2222: l_med_levy number;
2223: l_fbt_rate number;
2224: l_procedure varchar2(240);

Line 2221: l_max_action_sequence pay_assignment_actions.action_sequence%type;

2217:
2218: r_global c_get_global%ROWTYPE;
2219: l_bal_value number;
2220: l_max_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2221: l_max_action_sequence pay_assignment_actions.action_sequence%type;
2222: l_med_levy number;
2223: l_fbt_rate number;
2224: l_procedure varchar2(240);
2225:

Line 2435: procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE

2431: -- In case of Allowance elements,builds a PL/SQL table with
2432: -- the Allowance Balance_Type_ID's
2433: --------------------------------------------------------------------+
2434:
2435: procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
2436: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
2437: ,p_effective_date in date
2438: ,p_pre01jul1983_ratio in number
2439: ,p_post30jun1983_ratio in number)

Line 2436: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE

2432: -- the Allowance Balance_Type_ID's
2433: --------------------------------------------------------------------+
2434:
2435: procedure archive_element_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
2436: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
2437: ,p_effective_date in date
2438: ,p_pre01jul1983_ratio in number
2439: ,p_post30jun1983_ratio in number)
2440: is

Line 2461: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,

2457: /*Bug 9147421 - Added check for element classification 'Foreign Tax Deductions'
2458: - Negate the amount for foreign tax deductions and classify as Tax Deductions
2459: */
2460: cursor c_ps_element_details
2461: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
2462: c_business_group_id hr_all_organization_units.organization_id%TYPE,
2463: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
2464: c_start_date date,
2465: c_end_date date)

Line 2463: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,

2459: */
2460: cursor c_ps_element_details
2461: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
2462: c_business_group_id hr_all_organization_units.organization_id%TYPE,
2463: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
2464: c_start_date date,
2465: c_end_date date)
2466: is
2467: select element_name,label classification_name,sum(amount) payment,sum(hours) hours,rate

Line 2492: ,pay_assignment_actions paa

2488: paa.source_action_id
2489: from pay_element_types_f pet
2490: ,pay_input_values_f piv1
2491: ,pay_element_classifications pec
2492: ,pay_assignment_actions paa
2493: ,pay_payroll_actions ppa
2494: ,per_assignments_f paaf
2495: ,pay_run_results prr
2496: ,pay_run_result_values prrv1

Line 2587: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,

2583: a condition to fetch amount value only if the element input value is of 'Pay Value'.
2584: Removed references to hours and rate columns from the cursor ,as they are not displayed anywhere in EOY reports. */
2585: /* bug 12615137 - Added ORDERED hint and re-arranged FROM clause */
2586: cursor c_ps_alw_details
2587: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
2588: c_business_group_id hr_all_organization_units.organization_id%TYPE,
2589: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
2590: c_start_date date,
2591: c_end_date date) is

Line 2589: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,

2585: /* bug 12615137 - Added ORDERED hint and re-arranged FROM clause */
2586: cursor c_ps_alw_details
2587: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
2588: c_business_group_id hr_all_organization_units.organization_id%TYPE,
2589: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
2590: c_start_date date,
2591: c_end_date date) is
2592: select /*+ ORDERED */ element_name,label, sum(amount) payment
2593: from

Line 2602: ,pay_assignment_actions pac

2598: prr.run_result_id,
2599: pac.source_action_id
2600: FROM
2601: per_all_assignments_f paa
2602: ,pay_assignment_actions pac
2603: ,pay_payroll_actions ppa
2604: ,pay_run_results prr
2605: ,pay_element_types_f pet
2606: ,pay_input_values_f piv

Line 2912: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type)

2908: element section */
2909: /*bug8711855 - p_assignment_action_id and p_registered_employer parameter are added to call
2910: pay_au_payment_summary.get_retro_lumpsumE_value function */
2911: --------------------------------------------------------------------+
2912: procedure Adjust_lumpsum_E_payments(p_assignment_id in pay_assignment_actions.assignment_id%type)
2913: is
2914:
2915: l_procedure varchar2(240);
2916: v_lump_sum_E_ytd number;

Line 2919: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

2915: l_procedure varchar2(240);
2916: v_lump_sum_E_ytd number;
2917: v_adj_lump_sum_E_ptd number; /* Bug 4201894 */
2918: v_adj_lump_sum_pre_tax number;
2919: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
2920:
2921:
2922: begin
2923:

Line 2964: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type

2960: -- Retro Payments.
2961: --------------------------------------------------------------------+
2962:
2963: /* bug 7571001 - the way to retrieve allowance is based on Balance Attribute */
2964: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
2965: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
2966: is
2967:
2968:

Line 2965: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type)

2961: --------------------------------------------------------------------+
2962:
2963: /* bug 7571001 - the way to retrieve allowance is based on Balance Attribute */
2964: procedure get_allowance_balances(p_assignment_id in pay_assignment_actions.assignment_id%type
2965: ,p_run_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
2966: is
2967:
2968:
2969: CURSOR c_allowance_balances IS

Line 3225: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE

3221: -- Normal Balances - AU_BALANCE_RECON_DETAILS_YTD
3222: -- Payment Summary Balances - AU_PS_BALANCE_RECON_DETAILS
3223: --------------------------------------------------------------------+
3224:
3225: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
3226: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
3227: ,p_effective_date in date
3228: ,p_pre01jul1983_ratio in number
3229: ,p_post30jun1983_ratio in number

Line 3226: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE

3222: -- Payment Summary Balances - AU_PS_BALANCE_RECON_DETAILS
3223: --------------------------------------------------------------------+
3224:
3225: procedure archive_balance_details(p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
3226: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
3227: ,p_effective_date in date
3228: ,p_pre01jul1983_ratio in number
3229: ,p_post30jun1983_ratio in number
3230: ,p_run_action_sequence in pay_assignment_actions.action_sequence%type)

Line 3230: ,p_run_action_sequence in pay_assignment_actions.action_sequence%type)

3226: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
3227: ,p_effective_date in date
3228: ,p_pre01jul1983_ratio in number
3229: ,p_post30jun1983_ratio in number
3230: ,p_run_action_sequence in pay_assignment_actions.action_sequence%type)
3231: is
3232: l_procedure varchar2(80);
3233:
3234: l_YTD_TAXABLE_EARNINGS number;