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_PAYTAX_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 44: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;

40: g_debug boolean;
41: g_package varchar2(26);
42:
43:
44: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
45: g_business_group_id hr_all_organization_units.organization_id%type;
46: g_prev_assignment_id number;
47: g_le_taxable_income number;
48: g_count number;

Line 295: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

291: * 4. spawn_archive_reports
292: */
293:
294: procedure range_code
295: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
296: ,p_sql out NOCOPY varchar2
297: ) is
298:
299: l_procedure varchar2(200) ;

Line 312: ' pay_payroll_actions pa' ||

308: -- Archive the payroll action level data and EIT defintions.
309: -- sql string to SELECT a range of assignments eligible for archival.
310: p_sql := ' select distinct p.person_id' ||
311: ' from per_people_f p,' ||
312: ' pay_payroll_actions pa' ||
313: ' where pa.payroll_action_id = :payroll_action_id' ||
314: ' and p.business_group_id = pa.business_group_id' ||
315: ' order by p.person_id';
316:

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

318:
319: end range_code;
320:
321: procedure initialization_code
322: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
323: is
324: l_procedure varchar2(200) ;
325: l_defined_balance_id number;
326: l_term_defined_balance_id number;

Line 338: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

334: -- Description : Fetches User Parameters from Legislative_paramters
335: -- column.
336: --------------------------------------------------------------------+
337:
338: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
339: IS
340: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
341: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
342: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */

Line 356: FROM pay_payroll_actions ppa

352: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
353: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
354: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
355: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
356: FROM pay_payroll_actions ppa
357: WHERE ppa.payroll_action_id = c_payroll_action_id;
358:
359:
360: /* 4713372 */

Line 415: from pay_payroll_actions ppa,

411: c_end_date date)
412: is
413: select distinct per_information2, paa.tax_unit_id,
414: assignment_action_id assignment_action_id
415: from pay_payroll_actions ppa,
416: pay_assignment_actions paa,
417: per_people_f pap,
418: per_assignments_f paf
419: where paa.payroll_action_id = ppa.payroll_action_id

Line 560: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

556: -- Depending on the parameters passed,the appropriate cursor is used.
557: --------------------------------------------------------------------+
558:
559: procedure assignment_action_code
560: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
561: ,p_start_person in per_all_people_f.person_id%type
562: ,p_end_person in per_all_people_f.person_id%type
563: ,p_chunk in number
564: ) is

Line 569: (p_payroll_action_id pay_payroll_actions.payroll_action_id%type

565:
566:
567:
568: cursor csr_assignment_period
569: (p_payroll_action_id pay_payroll_actions.payroll_action_id%type
570: ,p_start_person per_all_people_f.person_id%type
571: ,p_end_person per_all_people_f.person_id%type
572: ,p_report_type varchar2
573: ,p_business_group_id hr_all_organization_units.organization_id%type

Line 587: pay_payroll_actions ppa,

583: paa.source_action_id master_action_id,
584: paa2.tax_unit_id master_tax_unit_id
585: from per_people_f pap,
586: per_assignments_f paaf,
587: pay_payroll_actions ppa,
588: pay_payroll_actions ppa1,
589: pay_assignment_actions paa,
590: pay_assignment_actions paa2,
591: per_periods_of_service pps

Line 588: pay_payroll_actions ppa1,

584: paa2.tax_unit_id master_tax_unit_id
585: from per_people_f pap,
586: per_assignments_f paaf,
587: pay_payroll_actions ppa,
588: pay_payroll_actions ppa1,
589: pay_assignment_actions paa,
590: pay_assignment_actions paa2,
591: per_periods_of_service pps
592: where ppa.payroll_action_id = p_payroll_action_id

Line 629: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

625: -- Description : Fetches User Parameters from Legislative_paramters
626: -- column.
627: --------------------------------------------------------------------+
628:
629: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
630: IS
631: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
632: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
633: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,

Line 647: FROM pay_payroll_actions ppa

643: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
644: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
645: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
646: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
647: FROM pay_payroll_actions ppa
648: WHERE ppa.payroll_action_id = c_payroll_action_id;
649:
650:
651:

Line 769: ,p_effective_date in pay_payroll_actions.effective_date%type

765: end assignment_action_code;
766:
767: procedure archive_code
768: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
769: ,p_effective_date in pay_payroll_actions.effective_date%type
770: ) is
771:
772: /* 5893671*/
773: cursor c_get_employee_full_name (c_person_id number, c_end_date date, c_start_date date)

Line 819: pay_payroll_actions ppa,

815: hoi.org_information3 dge_group_name,
816: hl.meaning state_desc
817: from per_people_f pap,
818: per_assignments_f paaf,
819: pay_payroll_actions ppa,
820: pay_payroll_actions ppa1,
821: pay_assignment_actions paa,
822: pay_assignment_actions paa2,
823: hr_soft_coding_keyflex hsc,

Line 820: pay_payroll_actions ppa1,

816: hl.meaning state_desc
817: from per_people_f pap,
818: per_assignments_f paaf,
819: pay_payroll_actions ppa,
820: pay_payroll_actions ppa1,
821: pay_assignment_actions paa,
822: pay_assignment_actions paa2,
823: hr_soft_coding_keyflex hsc,
824: hr_organization_units hou,

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

1121:
1122: end archive_code;
1123:
1124: procedure spawn_archive_reports
1125: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
1126: is
1127: l_count number;
1128: ps_request_id NUMBER;
1129: l_print_style VARCHAR2(2);

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

1142: -- Description : Fetches User Parameters from Legislative_paramters
1143: -- column.
1144: --------------------------------------------------------------------+
1145:
1146: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1147: IS
1148: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1149: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1150: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,

Line 1165: FROM pay_payroll_actions ppa

1161: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1162: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1163: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1164: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type
1165: FROM pay_payroll_actions ppa
1166: WHERE ppa.payroll_action_id = c_payroll_action_id;
1167:
1168:
1169:

Line 1170: cursor csr_get_report_name(c_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE) is

1166: WHERE ppa.payroll_action_id = c_payroll_action_id;
1167:
1168:
1169:
1170: cursor csr_get_report_name(c_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE) is
1171: select pay_core_utils.get_parameter('REP_NAME',legislative_parameters)
1172: from pay_payroll_actions ppa
1173: where ppa.payroll_Action_id = c_payroll_Action_id;
1174:

Line 1172: from pay_payroll_actions ppa

1168:
1169:
1170: cursor csr_get_report_name(c_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE) is
1171: select pay_core_utils.get_parameter('REP_NAME',legislative_parameters)
1172: from pay_payroll_actions ppa
1173: where ppa.payroll_Action_id = c_payroll_Action_id;
1174:
1175: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS
1176: SELECT printer,

Line 1180: FROM pay_payroll_actions pact,

1176: SELECT printer,
1177: print_style,
1178: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
1179: ,number_of_copies
1180: FROM pay_payroll_actions pact,
1181: fnd_concurrent_requests fcr
1182: WHERE fcr.request_id = pact.request_id
1183: AND pact.payroll_action_id = p_payroll_action_id;
1184: