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.PY_ZA_TAX_REG dependencies on PER_TIME_PERIODS

Line 99: g_start_period_id per_time_periods.time_period_id%TYPE;

95: -- Package Globals
96: ------------------
97: g_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
98: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
99: g_start_period_id per_time_periods.time_period_id%TYPE;
100: g_end_period_id per_time_periods.time_period_id%TYPE;
101: g_period_num per_time_periods.period_num%TYPE;
102: g_period_start_date per_time_periods.start_date%TYPE;
103: g_period_end_date per_time_periods.end_date%TYPE;

Line 100: g_end_period_id per_time_periods.time_period_id%TYPE;

96: ------------------
97: g_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
98: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
99: g_start_period_id per_time_periods.time_period_id%TYPE;
100: g_end_period_id per_time_periods.time_period_id%TYPE;
101: g_period_num per_time_periods.period_num%TYPE;
102: g_period_start_date per_time_periods.start_date%TYPE;
103: g_period_end_date per_time_periods.end_date%TYPE;
104: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

Line 101: g_period_num per_time_periods.period_num%TYPE;

97: g_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
98: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
99: g_start_period_id per_time_periods.time_period_id%TYPE;
100: g_end_period_id per_time_periods.time_period_id%TYPE;
101: g_period_num per_time_periods.period_num%TYPE;
102: g_period_start_date per_time_periods.start_date%TYPE;
103: g_period_end_date per_time_periods.end_date%TYPE;
104: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
105: g_include_asg VARCHAR2(1);

Line 102: g_period_start_date per_time_periods.start_date%TYPE;

98: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
99: g_start_period_id per_time_periods.time_period_id%TYPE;
100: g_end_period_id per_time_periods.time_period_id%TYPE;
101: g_period_num per_time_periods.period_num%TYPE;
102: g_period_start_date per_time_periods.start_date%TYPE;
103: g_period_end_date per_time_periods.end_date%TYPE;
104: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
105: g_include_asg VARCHAR2(1);
106: g_retrieve_ptd BOOLEAN;

Line 103: g_period_end_date per_time_periods.end_date%TYPE;

99: g_start_period_id per_time_periods.time_period_id%TYPE;
100: g_end_period_id per_time_periods.time_period_id%TYPE;
101: g_period_num per_time_periods.period_num%TYPE;
102: g_period_start_date per_time_periods.start_date%TYPE;
103: g_period_end_date per_time_periods.end_date%TYPE;
104: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
105: g_include_asg VARCHAR2(1);
106: g_retrieve_ptd BOOLEAN;
107: g_retrieve_mtd BOOLEAN;

Line 240: , p_action_period_id IN per_time_periods.time_period_id%TYPE

236: -- ptd_value
237: -------------------------------------------------------------------------------
238: FUNCTION ptd_value (
239: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
240: , p_action_period_id IN per_time_periods.time_period_id%TYPE
241: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
242: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
243: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
244: )

Line 942: , p_period_end_date IN per_time_periods.end_date%TYPE

938: -- It is called from the value set PY_SRS_ZA_TX_RGSTR_ASG
939: -------------------------------------------------------------------------------
940: FUNCTION include_assignment (
941: p_asg_id IN per_all_assignments_f.assignment_id%TYPE
942: , p_period_end_date IN per_time_periods.end_date%TYPE
943: , p_include_flag IN VARCHAR2
944: )
945: RETURN VARCHAR2 AS
946: ------------

Line 1084: per_time_periods ptp

1080: IS
1081: SELECT
1082: MIN(ptp.time_period_id) min_time_period
1083: FROM
1084: per_time_periods ptp
1085: WHERE
1086: ptp.payroll_id = g_payroll_id
1087: AND ptp.prd_information1 =
1088: (

Line 1090: FROM per_time_periods ptp2

1086: ptp.payroll_id = g_payroll_id
1087: AND ptp.prd_information1 =
1088: (
1089: SELECT ptp2.prd_information1
1090: FROM per_time_periods ptp2
1091: WHERE ptp2.payroll_id = g_payroll_id
1092: AND ptp2.time_period_id = g_end_period_id
1093: );
1094: ---------

Line 1102: FROM per_time_periods ptp

1098: IS
1099: SELECT ptp.period_num
1100: , ptp.start_date
1101: , ptp.end_date
1102: FROM per_time_periods ptp
1103: WHERE ptp.time_period_id = g_end_period_id;
1104: ------------
1105: -- Variables
1106: ------------

Line 1107: l_min_period_id per_time_periods.time_period_id%TYPE;

1103: WHERE ptp.time_period_id = g_end_period_id;
1104: ------------
1105: -- Variables
1106: ------------
1107: l_min_period_id per_time_periods.time_period_id%TYPE;
1108: l_period_info csr_period_details%ROWTYPE;
1109: --
1110: -------------------------------------------------------------------------------
1111: BEGIN -- MAIN --

Line 1194: , p_start_period_id IN per_time_periods.time_period_id%TYPE

1190: -- set_globals
1191: -------------------------------------------------------------------------------
1192: PROCEDURE set_globals (
1193: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1194: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1195: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1196: , p_include IN VARCHAR2
1197: , p_retrieve_ptd IN VARCHAR2
1198: , p_retrieve_mtd IN VARCHAR2

Line 1195: , p_end_period_id IN per_time_periods.time_period_id%TYPE

1191: -------------------------------------------------------------------------------
1192: PROCEDURE set_globals (
1193: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1194: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1195: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1196: , p_include IN VARCHAR2
1197: , p_retrieve_ptd IN VARCHAR2
1198: , p_retrieve_mtd IN VARCHAR2
1199: , p_retrieve_ytd IN VARCHAR2

Line 1387: , p_start_period_id IN per_time_periods.time_period_id%TYPE

1383: -- processed assignment balance value information
1384: -------------------------------------------------------------------------------
1385: PROCEDURE pre_process (
1386: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1387: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1388: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1389: , p_include IN VARCHAR2
1390: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1391: , p_retrieve_ptd IN VARCHAR2

Line 1388: , p_end_period_id IN per_time_periods.time_period_id%TYPE

1384: -------------------------------------------------------------------------------
1385: PROCEDURE pre_process (
1386: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1387: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1388: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1389: , p_include IN VARCHAR2
1390: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1391: , p_retrieve_ptd IN VARCHAR2
1392: , p_retrieve_mtd IN VARCHAR2

Line 1396: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE

1392: , p_retrieve_mtd IN VARCHAR2
1393: , p_retrieve_ytd IN VARCHAR2
1394: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
1395: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
1396: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
1397: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
1398: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
1399: , p_tot_employees OUT NOCOPY NUMBER
1400: , p_tot_assignments OUT NOCOPY NUMBER

Line 1397: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE

1393: , p_retrieve_ytd IN VARCHAR2
1394: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
1395: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
1396: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
1397: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
1398: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
1399: , p_tot_employees OUT NOCOPY NUMBER
1400: , p_tot_assignments OUT NOCOPY NUMBER
1401: )

Line 1398: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE

1394: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
1395: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
1396: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
1397: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
1398: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
1399: , p_tot_employees OUT NOCOPY NUMBER
1400: , p_tot_assignments OUT NOCOPY NUMBER
1401: )
1402: AS

Line 1413: , p_start_period_id IN per_time_periods.time_period_id%TYPE

1409: -----------------------------------------------------------------
1410: -- Bug 5330452
1411: CURSOR csr_processed_assignments (
1412: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1413: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1414: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1415: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
1416: )
1417: IS

Line 1414: , p_end_period_id IN per_time_periods.time_period_id%TYPE

1410: -- Bug 5330452
1411: CURSOR csr_processed_assignments (
1412: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1413: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1414: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1415: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
1416: )
1417: IS
1418: SELECT

Line 1438: , (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id) ptp

1434: , hr_organization_information oit
1435: , per_assignment_extra_info aei
1436: , per_assignments_f asg
1437: , per_people_f pap
1438: , (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id) ptp
1439: WHERE
1440: ppa.payroll_id = p_payroll_id
1441: AND ppa.time_period_id >= p_start_period_id
1442: AND ppa.time_period_id <= p_end_period_id

Line 1492: , p_start_period_id IN per_time_periods.time_period_id%TYPE

1488: -----------------------------------------------------------
1489: CURSOR csr_irp5_balances (
1490: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1491: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
1492: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1493: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1494: )
1495: IS
1496: SELECT DISTINCT

Line 1493: , p_end_period_id IN per_time_periods.time_period_id%TYPE

1489: CURSOR csr_irp5_balances (
1490: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1491: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
1492: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1493: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1494: )
1495: IS
1496: SELECT DISTINCT
1497: pbc.full_balance_name bal_name

Line 1513: AND ppa.effective_date >= (select start_date from per_time_periods ptp where ptp.time_period_id = p_start_period_id)

1509: AND prr.assignment_action_id = paa.assignment_action_id
1510: AND paa.assignment_id = p_asg_id
1511: AND ppa.payroll_action_id = paa.payroll_action_id
1512: AND ppa.action_type IN ('R', 'I', 'B', 'Q', 'V')
1513: AND ppa.effective_date >= (select start_date from per_time_periods ptp where ptp.time_period_id = p_start_period_id)
1514: AND ppa.effective_date <= (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id)
1515: AND pbc.balance_type_id = feed.balance_type_id
1516: AND pbc.balance_sequence = 1;
1517: ------------

Line 1514: AND ppa.effective_date <= (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id)

1510: AND paa.assignment_id = p_asg_id
1511: AND ppa.payroll_action_id = paa.payroll_action_id
1512: AND ppa.action_type IN ('R', 'I', 'B', 'Q', 'V')
1513: AND ppa.effective_date >= (select start_date from per_time_periods ptp where ptp.time_period_id = p_start_period_id)
1514: AND ppa.effective_date <= (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id)
1515: AND pbc.balance_type_id = feed.balance_type_id
1516: AND pbc.balance_sequence = 1;
1517: ------------
1518: -- Variables