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_PAYROLL_ACTIONS

Line 29: *** 09-OCT-03 Ragvoind 115.20 Bug#3034189 - Removed the usage of index INDEX(rppa pay_payroll_actions_pk) from cursor c_asgids.

25: *** If single Lump sum E payment is less than 400, then the amount is subtracted from Lump sum E.
26: *** 21 Aug 03 punmehta 115.18 Bug#3095923 - Modified the Cursor c_get_pay_earned_date to fetch effective_date instead of date_earned
27: *** 22-AUG-03 punmehta 115.19 Bug#3095923 - Modified the Cursor name c_get_pay_earned_date
28: *** to c_get_pay_effective_date and variable name of date_earned to effective_date
29: *** 09-OCT-03 Ragvoind 115.20 Bug#3034189 - Removed the usage of index INDEX(rppa pay_payroll_actions_pk) from cursor c_asgids.
30: *** 20-OCT-03 punmehta 115.21 Bug#3193479 - Implemented Batch Balance Retrieval. for that created new function to populate
31: *** global plsql table and other functions gets the balance value from this function.
32: *** 21-OCT-03 punmehta 115.22 Bug#3193479 - Added check for g_debug before tracing
33: *** 21-OCT-03 punmehta 115.23 Bug#3193479 - Modified OUT with OUT NOCOPY

Line 241: PAY_PAYROLL_ACTIONS PPA

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
245: AND pba.defined_balance_id = pdb.defined_balance_id

Line 686: , pay_payroll_actions ppa

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
690: and paa.assignment_id = c_assignment_id

Line 1532: ,p_year_start in pay_payroll_Actions.effective_date%type

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:
1536: e_prepost_error EXCEPTION;

Line 1533: ,p_year_end in pay_payroll_Actions.effective_date%type)

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:
1536: e_prepost_error EXCEPTION;
1537:

Line 1558: c_lst_year_start in pay_payroll_actions.effective_date%type,

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
1562: SELECT distinct nvl(current_employee_flag,'N') current_employee_flag

Line 1559: c_year_start in pay_payroll_actions.effective_date%type,

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
1562: SELECT distinct nvl(current_employee_flag,'N') current_employee_flag
1563: ,actual_termination_date

Line 1560: c_year_end in pay_payroll_actions.effective_date%type

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
1562: SELECT distinct nvl(current_employee_flag,'N') current_employee_flag
1563: ,actual_termination_date
1564: ,date_start

Line 2284: pay_payroll_actions paas

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'
2288: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'

Line 2801: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

2797: -- of assignments eligible for archival.
2798: --------------------------------------------------------------------
2799:
2800: procedure range_code
2801: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2802: p_sql out nocopy varchar2) is
2803: begin
2804: g_debug := hr_utility.debug_enabled;
2805: IF g_debug THEN

Line 2810: ' pay_payroll_actions pa' ||

2806: hr_utility.set_location('Start of range_code',1);
2807: END if;
2808: p_sql := ' select distinct p.person_id' ||
2809: ' from per_people_f p,' ||
2810: ' pay_payroll_actions pa' ||
2811: ' where pa.payroll_action_id = :payroll_action_id' ||
2812: ' and p.business_group_id = pa.business_group_id' ||
2813: ' order by p.person_id';
2814: IF g_debug THEN

Line 2828: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

2824: -- no archival is required.
2825: --------------------------------------------------------------------
2826:
2827: procedure initialization_code
2828: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
2829: begin
2830: NULL;
2831: END;
2832:

Line 2921: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

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,
2922: p_start_person_id in per_all_people_f.person_id%type,
2923: p_end_person_id in per_all_people_f.person_id%type,
2924: p_chunk in number) is
2925:

Line 2962: from pay_payroll_actions

2958: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
2959: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
2960: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
2961: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
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

Line 2983: INDEX(rppa pay_payroll_actions_pk)

2979: p_lst_year_start date
2980: )
2981: is
2982: SELECT /*+ INDEX(pap per_people_f_pk)
2983: INDEX(rppa pay_payroll_actions_pk)
2984: INDEX(paa per_assignments_f_N12)
2985: INDEX(pps per_periods_of_service_pk)
2986: */ paa.assignment_id
2987: from per_people_f pap

Line 2989: ,pay_payroll_actions rppa

2985: INDEX(pps per_periods_of_service_pk)
2986: */ paa.assignment_id
2987: from per_people_f pap
2988: ,per_assignments_f paa
2989: ,pay_payroll_actions rppa
2990: ,per_periods_of_service pps
2991: where rppa.payroll_action_id = p_payroll_action_id
2992: and pap.person_id between p_start_person_id and p_end_person_id
2993: and pap.person_id = paa.person_id

Line 3013: ,pay_payroll_actions rppa

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
3017: and rppa.payroll_action_id = rpac.payroll_action_id

Line 3028: ,pay_payroll_actions rppa

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
3032: + decode(rppa.payroll_id, 0, 0, 0),p_legal_employer,null,null,null,null) > to_number(g_fbt_threshold)

Line 3072: ,pay_payroll_actions rppa

3068: IS
3069: SELECT paa.assignment_id
3070: from per_people_f pap
3071: ,per_assignments_f paa
3072: ,pay_payroll_actions rppa
3073: ,per_periods_of_service pps
3074: ,pay_population_ranges ppr
3075: where rppa.payroll_action_id = p_payroll_action_id
3076: and rppa.payroll_action_id = ppr.payroll_action_id

Line 3102: ,pay_payroll_actions rppa

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
3106: and rppa.payroll_action_id = rpac.payroll_action_id

Line 3117: ,pay_payroll_actions rppa

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
3121: + decode(rppa.payroll_id, 0, 0, 0),p_legal_employer,null,null,null,null) > to_number(g_fbt_threshold)

Line 3149: INDEX(rppa pay_payroll_actions_pk)

3145: is
3146: SELECT /*+ INDEX(pap per_people_f_pk)
3147: INDEX(paa per_assignments_f_fk1)
3148: INDEX(paa per_assignments_f_N12)
3149: INDEX(rppa pay_payroll_actions_pk)
3150: INDEX(pps per_periods_of_service_n3)
3151: */ distinct paa.assignment_id
3152: from per_people_f pap
3153: ,per_assignments_f paa

Line 3154: ,pay_payroll_actions rppa

3150: INDEX(pps per_periods_of_service_n3)
3151: */ distinct paa.assignment_id
3152: from per_people_f pap
3153: ,per_assignments_f paa
3154: ,pay_payroll_actions rppa
3155: ,per_periods_of_service pps
3156: where rppa.payroll_action_id = p_payroll_action_id
3157: and pap.person_id between p_start_person_id and p_end_person_id
3158: and pap.person_id = paa.person_id

Line 3178: ,pay_payroll_actions rppa

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
3182: and rppa.payroll_action_id = rpac.payroll_action_id

Line 3193: ,pay_payroll_actions rppa

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
3197: + decode(rppa.payroll_id, 0, 0, 0),p_legal_employer,null,null,null,null) > to_number(g_fbt_threshold)

Line 3440: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

3436: -- And the report displays detials for all the archived assignments.
3437: --------------------------------------------------------------------
3438:
3439: PROCEDURE spawn_ps_report
3440: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
3441:
3442: ps_request_id NUMBER;
3443: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
3444: l_business_group_id number;

Line 3443: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

3439: PROCEDURE spawn_ps_report
3440: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
3441:
3442: ps_request_id NUMBER;
3443: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
3444: l_business_group_id number;
3445: l_start_date date;
3446: l_end_date date;
3447: l_effective_date date;

Line 3468: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

3464: -- Description : Fetches User Parameters from Legislative_paramters
3465: -- column.
3466: --------------------------------------------------------------------+
3467:
3468: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3469: IS
3470: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
3471: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
3472: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer

Line 3478: from pay_payroll_actions

3474: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
3475: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
3476: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
3477: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
3478: from pay_payroll_actions
3479: where payroll_action_id =c_payroll_Action_id;
3480:
3481:
3482:

Line 3488: FROM pay_payroll_actions pact,

3484: SELECT printer,
3485: print_style,
3486: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
3487: ,number_of_copies /* Bug 4116833 */
3488: FROM pay_payroll_actions pact,
3489: fnd_concurrent_requests fcr
3490: WHERE fcr.request_id = pact.request_id
3491: AND pact.payroll_action_id = p_payroll_action_id;
3492: