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_PAYROLL_ACTIONS

Line 118: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;

114:
115: Any changes made to this package must be Functionally/Technically tested against both reports.
116: */
117:
118: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
119: g_business_group_id hr_all_organization_units.organization_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;

Line 200: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

196: --
197: --------------------------------------------------------------------
198:
199: procedure range_code
200: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
201: ,p_sql out NOCOPY varchar2
202: ) is
203:
204: l_procedure varchar2(200) ;

Line 219: ' pay_payroll_actions pa' ||

215: -- Archive the payroll action level data and EIT defintions.
216: -- sql string to SELECT a range of assignments eligible for archival.
217: p_sql := ' select distinct p.person_id' ||
218: ' from per_people_f p,' ||
219: ' pay_payroll_actions pa' ||
220: ' where pa.payroll_action_id = :payroll_action_id' ||
221: ' and p.business_group_id = pa.business_group_id' ||
222: ' order by p.person_id';
223:

Line 244: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

240: and removed 'Other Income' balance. */
241: /* Bug 8769345 - Added ETP Taxable and Tax Free balances to the cursor */
242:
243: procedure initialization_code
244: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
245: is
246:
247: CURSOR csr_defined_balance_id
248: IS

Line 351: from pay_payroll_actions

347: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') fbt_year_end_date
348: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_year_term
349: ,pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug 4142159*/
350: ,decode(pay_core_utils.get_parameter('REP_MODE',legislative_parameters),'SUMM','S','D') report_mode /*Bug 3891577*/
351: from pay_payroll_actions
352: where payroll_action_id = c_payroll_action_id;
353:
354: Cursor c_fbt_balance is
355: select pdb.defined_balance_id

Line 751: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

747: -- it then archives Payroll Run assignment action id details
748: --------------------------------------------------------------------+
749:
750: procedure assignment_action_code
751: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
752: ,p_start_person in per_all_people_f.person_id%type
753: ,p_end_person in per_all_people_f.person_id%type
754: ,p_chunk in number
755: ) is

Line 770: from pay_payroll_actions

766: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') fbt_year_end_date
767: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_year_term
768: ,pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug 4142159*/
769: ,decode(pay_core_utils.get_parameter('REP_MODE',legislative_parameters),'SUMM','S','D') report_mode /*Bug 3891577*/
770: from pay_payroll_actions
771: where payroll_action_id = c_payroll_action_id;
772:
773: --------------------------------------------------------------------+
774: -- Cursor : csr_assignment_paysum

Line 780: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

776: -- Returns DISTINCT assignment_id
777: --
778: --------------------------------------------------------------------+
779: cursor csr_assignment_paysum
780: (c_payroll_action_id pay_payroll_actions.payroll_action_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

Line 799: INDEX(rppa pay_payroll_actions_pk)

795: ) is
796: SELECT /*+ INDEX(pap per_people_f_pk)
797: INDEX(paa per_assignments_f_fk1)
798: INDEX(paa per_assignments_f_N12)
799: INDEX(rppa pay_payroll_actions_pk)
800: INDEX(pps per_periods_of_service_n3)
801: */ distinct paa.assignment_id
802: from per_people_f pap
803: ,per_assignments_f paa

Line 804: ,pay_payroll_actions rppa

800: INDEX(pps per_periods_of_service_n3)
801: */ distinct paa.assignment_id
802: from per_people_f pap
803: ,per_assignments_f paa
804: ,pay_payroll_actions rppa
805: ,per_periods_of_service pps
806: where rppa.payroll_action_id = c_payroll_action_id
807: and pap.person_id between c_start_person and c_end_person
808: and pap.person_id = paa.person_id

Line 827: ,pay_payroll_actions rppa

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
831: AND rppa.payroll_action_id = rpac.payroll_action_id

Line 841: ,pay_payroll_actions rppa

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

Line 863: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

859: -- Assignment.
860: --------------------------------------------------------------------+
861:
862: cursor csr_assignment_only_paysum
863: (c_payroll_action_id pay_payroll_actions.payroll_action_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

Line 882: INDEX(rppa pay_payroll_actions_pk)

878: ) is
879: SELECT /*+ INDEX(pap per_people_f_pk)
880: INDEX(paa per_assignments_f_fk1)
881: INDEX(paa per_assignments_f_N12)
882: INDEX(rppa pay_payroll_actions_pk)
883: INDEX(pps per_periods_of_service_n3)
884: */ distinct paa.assignment_id
885: from per_people_f pap
886: ,per_assignments_f paa

Line 887: ,pay_payroll_actions rppa

883: INDEX(pps per_periods_of_service_n3)
884: */ distinct paa.assignment_id
885: from per_people_f pap
886: ,per_assignments_f paa
887: ,pay_payroll_actions rppa
888: ,per_periods_of_service pps
889: where rppa.payroll_action_id = c_payroll_action_id
890: and pap.person_id between c_start_person and c_end_person
891: and pap.person_id = paa.person_id

Line 910: ,pay_payroll_actions rppa

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
914: AND rppa.payroll_action_id = rpac.payroll_action_id

Line 924: ,pay_payroll_actions rppa

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

Line 950: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type

946: --------------------------------------------------------------------+
947: */
948:
949: CURSOR csr_range_assignment_paysum
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

Line 969: ,pay_payroll_actions rppa

965: IS
966: SELECT paa.assignment_id
967: from per_people_f pap
968: ,per_assignments_f paa
969: ,pay_payroll_actions rppa
970: ,per_periods_of_service pps
971: ,pay_population_ranges ppr
972: WHERE rppa.payroll_action_id = c_payroll_action_id
973: AND rppa.payroll_action_id = ppr.payroll_action_id

Line 997: ,pay_payroll_actions rppa

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
1001: AND rppa.payroll_action_id = rpac.payroll_action_id

Line 1011: ,pay_payroll_actions rppa

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

Line 1264: ,p_effective_date in pay_payroll_actions.effective_date%type

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:
1268: --------------------------------------------------------------------+

Line 1404: , pay_payroll_actions ppa

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

Line 2195: , pay_payroll_actions ppa

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

Line 2493: ,pay_payroll_actions ppa

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
2497: ,pay_element_classifications pec2

Line 2603: ,pay_payroll_actions ppa

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
2607: ,pay_run_result_values prrv

Line 3529: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

3525:
3526: --------------------------------------------------------------------+
3527:
3528: procedure spawn_archive_reports
3529: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
3530: is
3531: l_count number;
3532: ps_request_id NUMBER;
3533: l_print_style VARCHAR2(2);

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

3541: -- Description : Fetches User Parameters from Legislative_paramters
3542: -- column.
3543: --------------------------------------------------------------------+
3544:
3545: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3546: IS
3547: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) business_group_id
3548: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
3549: ,pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id

Line 3560: from pay_payroll_actions

3556: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_year_term
3557: ,pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions /*Bug 4142159*/
3558: ,decode(pay_core_utils.get_parameter('REP_MODE',legislative_parameters),'SUMM','S','D') report_mode /* Bug 3891577*/
3559: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type
3560: from pay_payroll_actions
3561: where payroll_action_id = c_payroll_action_id;
3562:
3563:
3564: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS

Line 3569: FROM pay_payroll_actions pact,

3565: SELECT printer,
3566: print_style,
3567: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
3568: ,number_of_copies /* Bug 4116833 */
3569: FROM pay_payroll_actions pact,
3570: fnd_concurrent_requests fcr
3571: WHERE fcr.request_id = pact.request_id
3572: AND pact.payroll_action_id = p_payroll_action_id;
3573:

Line 3715: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

3711:
3712: end;
3713:
3714: procedure spawn_summary_reports
3715: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
3716: is
3717: l_count number;
3718: ps_request_id NUMBER;
3719: l_print_style VARCHAR2(2);

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

3726: -- Description : Fetches User Parameters from Legislative_paramters
3727: -- column.
3728: --------------------------------------------------------------------+
3729:
3730: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
3731: IS
3732: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) business_group_id
3733: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer
3734: ,pay_core_utils.get_parameter('PAYROLL',legislative_parameters) payroll_id

Line 3744: from pay_payroll_actions

3740: ,to_date('30-06-'||substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters),1,4),'DD-MM-YYYY') fbt_year_end_date
3741: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_year_term
3742: ,pay_core_utils.get_parameter('DEL_ACT',legislative_parameters) delete_actions
3743: ,decode(pay_core_utils.get_parameter('REP_MODE',legislative_parameters),'SUMM','S','D') report_mode
3744: from pay_payroll_actions
3745: where payroll_action_id = c_payroll_action_id;
3746:
3747:
3748: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS

Line 3753: FROM pay_payroll_actions pact,

3749: SELECT printer,
3750: print_style,
3751: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
3752: ,number_of_copies
3753: FROM pay_payroll_actions pact,
3754: fnd_concurrent_requests fcr
3755: WHERE fcr.request_id = pact.request_id
3756: AND pact.payroll_action_id = p_payroll_action_id;
3757: