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_RECON_SUMMARY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 240: PAY_ASSIGNMENT_ACTIONS PAC ,

236: PAY_ELEMENT_TYPES_F PET ,
237: PER_ALL_ASSIGNMENTS_F PAA ,
238: PER_PERIODS_OF_SERVICE PPS ,
239: PAY_RUN_RESULTS PRR ,
240: PAY_ASSIGNMENT_ACTIONS PAC ,
241: PAY_PAYROLL_ACTIONS PPA
242: WHERE pbad.attribute_name = 'AU_EOY_ALLOWANCE'
243: AND pbad.legislation_code = 'AU'
244: AND pbad.attribute_id = pba.attribute_id

Line 484: p_assignment_id pay_assignment_actions.assignment_id%type,

480: adjust_retro_group_allowances is called for 'G'.
481: ***************/
482: Function get_total_allowances ( p_year_start DATE,
483: p_year_end DATE,
484: p_assignment_id pay_assignment_actions.assignment_id%type,
485: p_assignment_action_id pay_assignment_actions.assignment_id%type,
486: p_tax_unit_id hr_all_organization_units.organization_id%type)
487: return number is
488:

Line 485: p_assignment_action_id pay_assignment_actions.assignment_id%type,

481: ***************/
482: Function get_total_allowances ( p_year_start DATE,
483: p_year_end DATE,
484: p_assignment_id pay_assignment_actions.assignment_id%type,
485: p_assignment_action_id pay_assignment_actions.assignment_id%type,
486: p_tax_unit_id hr_all_organization_units.organization_id%type)
487: return number is
488:
489: CURSOR get_alw_balance_name (p_def_bal_id pay_defined_balances.defined_balance_id%type) IS

Line 649: c_assignment_id pay_assignment_actions.assignment_id%type,

645:
646:
647:
648: Function get_total_fbt(c_year_start DATE,
649: c_assignment_id pay_assignment_actions.assignment_id%type,
650: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
651: c_fbt_rate ff_globals_f.global_value%TYPE,
652: c_ml_rate ff_globals_f.global_value%TYPE,
653: p_termination VARCHAR2)

Line 661: l_max_asg_action_id pay_assignment_actions.assignment_action_id%type;

657: l_reporting_amt number;
658: l_fbt_rate number;
659: l_medicare_levy number;
660: l_fbt_ratio number;
661: l_max_asg_action_id pay_assignment_actions.assignment_action_id%type;
662: l_fw_reporting_amt number;
663: /* Changes for 9147438 start */
664: l_fw_f_type varchar2(1);
665: l_fw_j_type varchar2(1);

Line 685: from pay_assignment_actions paa

681: c_tax_unit_id hr_all_organization_units.organization_id%TYPE,
682: c_year_start date,
683: c_year_end date ) is
684: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
685: from pay_assignment_actions paa
686: , pay_payroll_actions ppa
687: , per_assignments_f paf
688: where paa.assignment_id = paf.assignment_id
689: and paf.assignment_id = c_assignment_id

Line 1005: c_assignment_id pay_assignment_actions.assignment_id%type,

1001: end Total_Lump_Sum_D_Payments;
1002:
1003: /*bug8711855 - p_assignment_action_id parameter is added to call pay_au_payment_summary.get_retro_lumpsumE_value function */
1004: function Total_Lump_Sum_E_Payments(c_year_end DATE,
1005: c_assignment_id pay_assignment_actions.assignment_id%type,
1006: c_registered_employer NUMBER) --2610141
1007: return number is
1008:
1009: /*bug8711855 - Fetching Defined_Balance_Ids of Lump Sum E balances_PTD*/

Line 1531: p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type

1527: END populate_bal_ids;
1528:
1529: function etp_details
1530: (
1531: p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
1532: ,p_year_start in pay_payroll_Actions.effective_date%type
1533: ,p_year_end in pay_payroll_Actions.effective_date%type)
1534: return number is
1535:

Line 1557: CURSOR etp_code(c_assignment_id in pay_assignment_actions.assignment_id%type,

1553: l_etp_new_bal_total NUMBER ; /* Bug 9226023 - Variable declared to store the sum of Taxable and Tax Free portions of ETP balances
1554: introduced as part of patch 8769345*/
1555:
1556:
1557: CURSOR etp_code(c_assignment_id in pay_assignment_actions.assignment_id%type,
1558: c_lst_year_start in pay_payroll_actions.effective_date%type,
1559: c_year_start in pay_payroll_actions.effective_date%type,
1560: c_year_end in pay_payroll_actions.effective_date%type
1561: )is

Line 1746: c_assignment_id pay_assignment_actions.assignment_id%type,

1742:
1743:
1744: PROCEDURE get_value_bbr(c_year_start DATE,
1745: c_year_end DATE,
1746: c_assignment_id pay_assignment_actions.assignment_id%type,
1747: c_fbt_rate ff_globals_f.global_value%TYPE,
1748: c_ml_rate ff_globals_f.global_value%TYPE,
1749: p_assignment_action_id pay_assignment_actions.assignment_id%type,
1750: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,

Line 1749: p_assignment_action_id pay_assignment_actions.assignment_id%type,

1745: c_year_end DATE,
1746: c_assignment_id pay_assignment_actions.assignment_id%type,
1747: c_fbt_rate ff_globals_f.global_value%TYPE,
1748: c_ml_rate ff_globals_f.global_value%TYPE,
1749: p_assignment_action_id pay_assignment_actions.assignment_id%type,
1750: p_tax_unit_id hr_all_organization_units.organization_id%TYPE,
1751: p_termination_date DATE, --Bug 3098367
1752: p_display_flag OUT NOCOPY VARCHAR2, --Bug 3098367
1753: p_output_tab OUT NOCOPY bal_tab

Line 2283: pay_assignment_actions paat,

2279: c_financial_year varchar2)
2280: is
2281: SELECT distinct paat.assignment_id
2282: from pay_action_interlocks pail,
2283: pay_assignment_actions paat,
2284: pay_payroll_actions paas
2285: where paat.assignment_id = c_assignment_id
2286: and paas.action_type ='X'
2287: and paas.action_status ='C'

Line 2601: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL

2597:
2598: PROCEDURE get_group_values_bbr
2599: (p_year_start DATE
2600: ,p_year_end DATE
2601: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL
2602: ,p_date_earned IN date
2603: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
2604: ,p_group_output_tab OUT NOCOPY bal_tab ) IS
2605:

Line 2603: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE

2599: (p_year_start DATE
2600: ,p_year_end DATE
2601: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL
2602: ,p_date_earned IN date
2603: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
2604: ,p_group_output_tab OUT NOCOPY bal_tab ) IS
2605:
2606: BEGIN
2607:

Line 2662: , p_assignment_id IN pay_assignment_actions.assignment_id%type

2658:
2659: PROCEDURE get_assgt_curr_term_values_bbr
2660: ( p_year_start IN date
2661: , p_year_end IN date
2662: , p_assignment_id IN pay_assignment_actions.assignment_id%type
2663: , p_fbt_rate IN ff_globals_f.global_value%TYPE
2664: , p_ml_rate IN ff_globals_f.global_value%TYPE
2665: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
2666: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE

Line 2665: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type

2661: , p_year_end IN date
2662: , p_assignment_id IN pay_assignment_actions.assignment_id%type
2663: , p_fbt_rate IN ff_globals_f.global_value%TYPE
2664: , p_ml_rate IN ff_globals_f.global_value%TYPE
2665: , p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type
2666: , p_tax_unit_id IN hr_all_organization_units.organization_id%TYPE
2667: , p_emp_type IN varchar2
2668: , p_term_output_tab OUT NOCOPY bal_tab) IS
2669:

Line 2917: -- It inserts the record in pay_assignment_Actions

2913:
2914: --------------------------------------------------------------------
2915: -- This procedure further restricts the assignment_id's
2916: -- returned by range_code
2917: -- It inserts the record in pay_assignment_Actions
2918: -- Which are then used in main report query to get assignment_ids
2919: --------------------------------------------------------------------
2920: procedure assignment_action_code
2921: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

Line 2928: l_next_action_id pay_assignment_actions.assignment_action_id%type;

2924: p_chunk in number) is
2925:
2926:
2927: l_asgid per_assignments_f.assignment_id%type;
2928: l_next_action_id pay_assignment_actions.assignment_action_id%type;
2929:
2930:
2931: l_lst_yr_start date;
2932: l_lst_fbt_yr_start date;

Line 2966: select pay_assignment_actions_s.nextval

2962: from pay_payroll_actions
2963: where payroll_action_id =c_payroll_Action_id;
2964:
2965: cursor next_action_id is
2966: select pay_assignment_actions_s.nextval
2967: from dual;
2968:
2969: cursor c_asgids(p_assignment_id varchar2,
2970: p_business_group_id hr_organization_units.organization_id%type,

Line 3012: ,pay_assignment_actions rpac

3008: /* End of Bug: 3872211 */
3009: AND EXISTS (SELECT /*+ ORDERED */''
3010: FROM
3011: per_assignments_f paaf
3012: ,pay_assignment_actions rpac
3013: ,pay_payroll_actions rppa
3014: where rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
3015: and rppa.action_type in ('R','Q','B','I')
3016: and rpac.tax_unit_id = p_legal_employer

Line 3027: ,pay_assignment_actions rpac

3023: UNION
3024: SELECT /*+ ORDERED */''
3025: FROM
3026: per_assignments_f paaf
3027: ,pay_assignment_actions rpac
3028: ,pay_payroll_actions rppa
3029: where pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
3030: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end
3031: and pay_balance_pkg.get_value(g_fbt_defined_balance_id, rpac.assignment_action_id

Line 3101: ,pay_assignment_actions rpac

3097: /* End of Bug: 3872211 */
3098: AND EXISTS (SELECT /*+ ORDERED */''
3099: FROM
3100: per_assignments_f paaf
3101: ,pay_assignment_actions rpac
3102: ,pay_payroll_actions rppa
3103: where rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
3104: and rppa.action_type in ('R','Q','B','I')
3105: and rpac.tax_unit_id = p_legal_employer

Line 3116: ,pay_assignment_actions rpac

3112: UNION
3113: SELECT /*+ ORDERED */''
3114: FROM
3115: per_assignments_f paaf
3116: ,pay_assignment_actions rpac
3117: ,pay_payroll_actions rppa
3118: where pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
3119: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end
3120: and pay_balance_pkg.get_value(g_fbt_defined_balance_id, rpac.assignment_action_id

Line 3177: ,pay_assignment_actions rpac

3173: and paa.payroll_id like p_payroll_id
3174: AND EXISTS (SELECT /*+ ORDERED */''
3175: FROM
3176: per_assignments_f paaf
3177: ,pay_assignment_actions rpac
3178: ,pay_payroll_actions rppa
3179: where rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
3180: and rppa.action_type in ('R','Q','B','I')
3181: and rpac.tax_unit_id = p_legal_employer

Line 3192: ,pay_assignment_actions rpac

3188: UNION
3189: SELECT /*+ ORDERED */''
3190: FROM
3191: per_assignments_f paaf
3192: ,pay_assignment_actions rpac
3193: ,pay_payroll_actions rppa
3194: where pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */
3195: and rppa.effective_date between p_fbt_year_start and p_fbt_year_end
3196: and pay_balance_pkg.get_value(g_fbt_defined_balance_id, rpac.assignment_action_id

Line 3425: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,

3421: -- internally calls private procedures to archive balances ,
3422: -- employee details, employer details and supplier details .
3423: --------------------------------------------------------------------
3424: procedure archive_code
3425: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3426: p_effective_date in date)is
3427: begin
3428: NULL;
3429: END;