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 45: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;

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

Line 593: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

589: * 4. spawn_archive_reports
590: */
591:
592: procedure range_code
593: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
594: ,p_sql out NOCOPY varchar2
595: ) is
596:
597: l_procedure varchar2(200) ;

Line 610: ' pay_payroll_actions pa' ||

606: -- Archive the payroll action level data and EIT defintions.
607: -- sql string to SELECT a range of assignments eligible for archival.
608: p_sql := ' select distinct p.person_id' ||
609: ' from per_people_f p,' ||
610: ' pay_payroll_actions pa' ||
611: ' where pa.payroll_action_id = :payroll_action_id' ||
612: ' and p.business_group_id = pa.business_group_id' ||
613: ' order by p.person_id';
614:

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

616:
617: end range_code;
618:
619: procedure initialization_code
620: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
621: is
622: l_procedure varchar2(200) ;
623: l_defined_balance_id number;
624: l_term_defined_balance_id number;

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

632: -- Description : Fetches User Parameters from Legislative_paramters
633: -- column.
634: --------------------------------------------------------------------+
635:
636: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
637: IS
638: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
639: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
640: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period, /*4709766 */

Line 654: FROM pay_payroll_actions ppa

650: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
651: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
652: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
653: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
654: FROM pay_payroll_actions ppa
655: WHERE ppa.payroll_action_id = c_payroll_action_id;
656:
657:
658: /* 4713372 */

Line 713: from pay_payroll_actions ppa,

709: c_end_date date)
710: is
711: select distinct per_information2, paa.tax_unit_id,
712: assignment_action_id assignment_action_id
713: from pay_payroll_actions ppa,
714: pay_assignment_actions paa,
715: per_people_f pap,
716: per_assignments_f paf
717: where paa.payroll_action_id = ppa.payroll_action_id

Line 861: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type

857: -- Depending on the parameters passed,the appropriate cursor is used.
858: --------------------------------------------------------------------+
859:
860: procedure assignment_action_code
861: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type
862: ,p_start_person in per_all_people_f.person_id%type
863: ,p_end_person in per_all_people_f.person_id%type
864: ,p_chunk in number
865: ) is

Line 870: (p_payroll_action_id pay_payroll_actions.payroll_action_id%type

866:
867:
868:
869: cursor csr_assignment_period
870: (p_payroll_action_id pay_payroll_actions.payroll_action_id%type
871: ,p_start_person per_all_people_f.person_id%type
872: ,p_end_person per_all_people_f.person_id%type
873: ,p_report_type varchar2
874: ,p_business_group_id hr_all_organization_units.organization_id%type

Line 888: pay_payroll_actions ppa,

884: paa.source_action_id master_action_id,
885: paa2.tax_unit_id master_tax_unit_id
886: from per_people_f pap,
887: per_assignments_f paaf,
888: pay_payroll_actions ppa,
889: pay_payroll_actions ppa1,
890: pay_assignment_actions paa,
891: pay_assignment_actions paa2,
892: per_periods_of_service pps

Line 889: pay_payroll_actions ppa1,

885: paa2.tax_unit_id master_tax_unit_id
886: from per_people_f pap,
887: per_assignments_f paaf,
888: pay_payroll_actions ppa,
889: pay_payroll_actions ppa1,
890: pay_assignment_actions paa,
891: pay_assignment_actions paa2,
892: per_periods_of_service pps
893: where ppa.payroll_action_id = p_payroll_action_id

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

926: -- Description : Fetches User Parameters from Legislative_paramters
927: -- column.
928: --------------------------------------------------------------------+
929:
930: CURSOR csr_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
931: IS
932: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
933: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
934: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,

Line 948: FROM pay_payroll_actions ppa

944: pay_core_utils.get_parameter('WAT',legislative_parameters)wa_override_threshold,
945: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
946: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
947: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold
948: FROM pay_payroll_actions ppa
949: WHERE ppa.payroll_action_id = c_payroll_action_id;
950:
951:
952:

Line 1070: ,p_effective_date in pay_payroll_actions.effective_date%type

1066: end assignment_action_code;
1067:
1068: procedure archive_code
1069: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
1070: ,p_effective_date in pay_payroll_actions.effective_date%type
1071: ) is
1072:
1073: /* 5893671*/
1074: cursor c_get_employee_full_name (c_person_id number, c_end_date date, c_start_date date)

Line 1120: pay_payroll_actions ppa,

1116: hoi.org_information3 dge_group_name,
1117: hl.meaning state_desc
1118: from per_people_f pap,
1119: per_assignments_f paaf,
1120: pay_payroll_actions ppa,
1121: pay_payroll_actions ppa1,
1122: pay_assignment_actions paa,
1123: pay_assignment_actions paa2,
1124: hr_soft_coding_keyflex hsc,

Line 1121: pay_payroll_actions ppa1,

1117: hl.meaning state_desc
1118: from per_people_f pap,
1119: per_assignments_f paaf,
1120: pay_payroll_actions ppa,
1121: pay_payroll_actions ppa1,
1122: pay_assignment_actions paa,
1123: pay_assignment_actions paa2,
1124: hr_soft_coding_keyflex hsc,
1125: hr_organization_units hou,

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

1456:
1457: end archive_code;
1458:
1459: procedure spawn_archive_reports
1460: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
1461: is
1462: l_count number;
1463: ps_request_id NUMBER;
1464: l_print_style VARCHAR2(2);

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

1477: -- Description : Fetches User Parameters from Legislative_paramters
1478: -- column.
1479: --------------------------------------------------------------------+
1480:
1481: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
1482: IS
1483: SELECT pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id,
1484: pay_core_utils.get_parameter('LE',legislative_parameters) legal_employer,
1485: to_date(pay_core_utils.get_parameter('PERIOD',legislative_parameters),'YYYY/MM/DD') period,

Line 1500: FROM pay_payroll_actions ppa

1496: pay_core_utils.get_parameter('NTT',legislative_parameters)nt_override_threshold,
1497: pay_core_utils.get_parameter('SAT',legislative_parameters)sa_override_threshold,
1498: pay_core_utils.get_parameter('TAST',legislative_parameters)tas_override_threshold,
1499: pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters) p_output_type
1500: FROM pay_payroll_actions ppa
1501: WHERE ppa.payroll_action_id = c_payroll_action_id;
1502:
1503:
1504:

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

1501: WHERE ppa.payroll_action_id = c_payroll_action_id;
1502:
1503:
1504:
1505: cursor csr_get_report_name(c_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE) is
1506: select pay_core_utils.get_parameter('REP_NAME',legislative_parameters)
1507: from pay_payroll_actions ppa
1508: where ppa.payroll_Action_id = c_payroll_Action_id;
1509:

Line 1507: from pay_payroll_actions ppa

1503:
1504:
1505: cursor csr_get_report_name(c_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE) is
1506: select pay_core_utils.get_parameter('REP_NAME',legislative_parameters)
1507: from pay_payroll_actions ppa
1508: where ppa.payroll_Action_id = c_payroll_Action_id;
1509:
1510: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS
1511: SELECT printer,

Line 1515: FROM pay_payroll_actions pact,

1511: SELECT printer,
1512: print_style,
1513: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
1514: ,number_of_copies
1515: FROM pay_payroll_actions pact,
1516: fnd_concurrent_requests fcr
1517: WHERE fcr.request_id = pact.request_id
1518: AND pact.payroll_action_id = p_payroll_action_id;
1519: