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 153: g_start_period_id per_time_periods.time_period_id%TYPE;

149:
150: g_code code_desc_table;
151: g_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
152: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
153: g_start_period_id per_time_periods.time_period_id%TYPE;
154: g_end_period_id per_time_periods.time_period_id%TYPE;
155: g_period_num per_time_periods.period_num%TYPE;
156: g_period_start_date per_time_periods.start_date%TYPE;
157: g_period_end_date per_time_periods.end_date%TYPE;

Line 154: g_end_period_id per_time_periods.time_period_id%TYPE;

150: g_code code_desc_table;
151: g_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
152: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
153: g_start_period_id per_time_periods.time_period_id%TYPE;
154: g_end_period_id per_time_periods.time_period_id%TYPE;
155: g_period_num per_time_periods.period_num%TYPE;
156: g_period_start_date per_time_periods.start_date%TYPE;
157: g_period_end_date per_time_periods.end_date%TYPE;
158: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;

Line 155: g_period_num per_time_periods.period_num%TYPE;

151: g_tax_register_id pay_za_tax_registers.tax_register_id%TYPE;
152: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
153: g_start_period_id per_time_periods.time_period_id%TYPE;
154: g_end_period_id per_time_periods.time_period_id%TYPE;
155: g_period_num per_time_periods.period_num%TYPE;
156: g_period_start_date per_time_periods.start_date%TYPE;
157: g_period_end_date per_time_periods.end_date%TYPE;
158: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
159: g_include_asg VARCHAR2(1);

Line 156: g_period_start_date per_time_periods.start_date%TYPE;

152: g_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
153: g_start_period_id per_time_periods.time_period_id%TYPE;
154: g_end_period_id per_time_periods.time_period_id%TYPE;
155: g_period_num per_time_periods.period_num%TYPE;
156: g_period_start_date per_time_periods.start_date%TYPE;
157: g_period_end_date per_time_periods.end_date%TYPE;
158: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
159: g_include_asg VARCHAR2(1);
160: g_retrieve_ptd BOOLEAN;

Line 157: g_period_end_date per_time_periods.end_date%TYPE;

153: g_start_period_id per_time_periods.time_period_id%TYPE;
154: g_end_period_id per_time_periods.time_period_id%TYPE;
155: g_period_num per_time_periods.period_num%TYPE;
156: g_period_start_date per_time_periods.start_date%TYPE;
157: g_period_end_date per_time_periods.end_date%TYPE;
158: g_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
159: g_include_asg VARCHAR2(1);
160: g_retrieve_ptd BOOLEAN;
161: g_retrieve_mtd BOOLEAN;

Line 295: , p_action_period_id IN per_time_periods.time_period_id%TYPE

291: -- ptd_value
292: -------------------------------------------------------------------------------
293: FUNCTION ptd_value (
294: p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
295: , p_action_period_id IN per_time_periods.time_period_id%TYPE
296: , p_balance_type_id IN pay_balance_types.balance_type_id%TYPE
297: , p_balance_name IN pay_za_irp5_bal_codes.full_balance_name%TYPE
298: , p_effective_date IN pay_payroll_actions.effective_date%TYPE
299: )

Line 999: , p_period_end_date IN per_time_periods.end_date%TYPE

995: -- It is called from the value set PY_SRS_ZA_TX_RGSTR_ASG
996: -------------------------------------------------------------------------------
997: FUNCTION include_assignment (
998: p_asg_id IN per_all_assignments_f.assignment_id%TYPE
999: , p_period_end_date IN per_time_periods.end_date%TYPE
1000: , p_include_flag IN VARCHAR2
1001: )
1002: RETURN VARCHAR2 AS
1003: ------------

Line 1141: per_time_periods ptp

1137: IS
1138: SELECT
1139: MIN(ptp.time_period_id) min_time_period
1140: FROM
1141: per_time_periods ptp
1142: WHERE
1143: ptp.payroll_id = g_payroll_id
1144: AND ptp.prd_information1 =
1145: (

Line 1147: FROM per_time_periods ptp2

1143: ptp.payroll_id = g_payroll_id
1144: AND ptp.prd_information1 =
1145: (
1146: SELECT ptp2.prd_information1
1147: FROM per_time_periods ptp2
1148: WHERE ptp2.payroll_id = g_payroll_id
1149: AND ptp2.time_period_id = g_end_period_id
1150: );
1151: ---------

Line 1159: FROM per_time_periods ptp

1155: IS
1156: SELECT ptp.period_num
1157: , ptp.start_date
1158: , ptp.end_date
1159: FROM per_time_periods ptp
1160: WHERE ptp.time_period_id = g_end_period_id;
1161: ------------
1162: -- Variables
1163: ------------

Line 1164: l_min_period_id per_time_periods.time_period_id%TYPE;

1160: WHERE ptp.time_period_id = g_end_period_id;
1161: ------------
1162: -- Variables
1163: ------------
1164: l_min_period_id per_time_periods.time_period_id%TYPE;
1165: l_period_info csr_period_details%ROWTYPE;
1166: --
1167: -------------------------------------------------------------------------------
1168: BEGIN -- MAIN --

Line 1251: , p_start_period_id IN per_time_periods.time_period_id%TYPE

1247: -- set_globals
1248: -------------------------------------------------------------------------------
1249: PROCEDURE set_globals (
1250: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1251: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1252: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1253: , p_include IN VARCHAR2
1254: , p_retrieve_ptd IN VARCHAR2
1255: , p_retrieve_mtd IN VARCHAR2

Line 1252: , p_end_period_id IN per_time_periods.time_period_id%TYPE

1248: -------------------------------------------------------------------------------
1249: PROCEDURE set_globals (
1250: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1251: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1252: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1253: , p_include IN VARCHAR2
1254: , p_retrieve_ptd IN VARCHAR2
1255: , p_retrieve_mtd IN VARCHAR2
1256: , p_retrieve_ytd IN VARCHAR2

Line 1271: from per_time_periods

1267:
1268: CURSOR csr_tax_year
1269: IS
1270: select PRD_INFORMATION1
1271: from per_time_periods
1272: where PRD_INFORMATION_CATEGORY = 'ZA'
1273: and TIME_PERIOD_ID = p_end_period_id ;
1274:
1275: ------------

Line 1467: , p_start_period_id IN per_time_periods.time_period_id%TYPE

1463: -- processed assignment balance value information
1464: -------------------------------------------------------------------------------
1465: PROCEDURE pre_process (
1466: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1467: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1468: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1469: , p_include IN VARCHAR2
1470: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1471: , p_retrieve_ptd IN VARCHAR2

Line 1468: , p_end_period_id IN per_time_periods.time_period_id%TYPE

1464: -------------------------------------------------------------------------------
1465: PROCEDURE pre_process (
1466: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1467: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1468: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1469: , p_include IN VARCHAR2
1470: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1471: , p_retrieve_ptd IN VARCHAR2
1472: , p_retrieve_mtd IN VARCHAR2

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

1472: , p_retrieve_mtd IN VARCHAR2
1473: , p_retrieve_ytd IN VARCHAR2
1474: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
1475: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
1476: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
1477: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
1478: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
1479: , p_tot_employees OUT NOCOPY NUMBER
1480: , p_tot_assignments OUT NOCOPY NUMBER

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

1473: , p_retrieve_ytd IN VARCHAR2
1474: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
1475: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
1476: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
1477: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
1478: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
1479: , p_tot_employees OUT NOCOPY NUMBER
1480: , p_tot_assignments OUT NOCOPY NUMBER
1481: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804

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

1474: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
1475: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
1476: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
1477: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
1478: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
1479: , p_tot_employees OUT NOCOPY NUMBER
1480: , p_tot_assignments OUT NOCOPY NUMBER
1481: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804
1482: )

Line 1494: , p_start_period_id IN per_time_periods.time_period_id%TYPE

1490: -----------------------------------------------------------------
1491: -- Bug 5330452
1492: CURSOR csr_processed_assignments (
1493: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1494: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1495: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1496: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
1497: )
1498: IS

Line 1495: , p_end_period_id IN per_time_periods.time_period_id%TYPE

1491: -- Bug 5330452
1492: CURSOR csr_processed_assignments (
1493: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
1494: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1495: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1496: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
1497: )
1498: IS
1499: SELECT

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

1516: , hr_organization_information oit
1517: , per_assignment_extra_info aei
1518: , per_assignments_f asg
1519: , per_people_f pap
1520: , (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id) ptp
1521: WHERE
1522: ppa.payroll_id = p_payroll_id
1523: AND ppa.time_period_id >= p_start_period_id
1524: AND ppa.time_period_id <= p_end_period_id

Line 1575: , p_start_period_id IN per_time_periods.time_period_id%TYPE

1571: CURSOR csr_irp5_balances (
1572: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1573: p_action_seq IN pay_assignment_actions.action_sequence%TYPE
1574: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
1575: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1576: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1577: )
1578: IS
1579: SELECT DISTINCT

Line 1576: , p_end_period_id IN per_time_periods.time_period_id%TYPE

1572: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1573: p_action_seq IN pay_assignment_actions.action_sequence%TYPE
1574: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
1575: , p_start_period_id IN per_time_periods.time_period_id%TYPE
1576: , p_end_period_id IN per_time_periods.time_period_id%TYPE
1577: )
1578: IS
1579: SELECT DISTINCT
1580: pbc.full_balance_name bal_name

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

1593: AND prr.assignment_action_id = paa.assignment_action_id
1594: AND paa.assignment_id = p_asg_id
1595: AND ppa.payroll_action_id = paa.payroll_action_id
1596: AND ppa.action_type IN ('R', 'I', 'B', 'Q', 'V')
1597: AND ppa.effective_date >= (select start_date from per_time_periods ptp where ptp.time_period_id = p_start_period_id)
1598: AND ppa.effective_date <= (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id)
1599: AND pbc.balance_type_id = feed.balance_type_id
1600: AND (pbc.balance_sequence = 1
1601: or (pbc.code=4005 and pbc.balance_sequence=2)

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

1594: AND paa.assignment_id = p_asg_id
1595: AND ppa.payroll_action_id = paa.payroll_action_id
1596: AND ppa.action_type IN ('R', 'I', 'B', 'Q', 'V')
1597: AND ppa.effective_date >= (select start_date from per_time_periods ptp where ptp.time_period_id = p_start_period_id)
1598: AND ppa.effective_date <= (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id)
1599: AND pbc.balance_type_id = feed.balance_type_id
1600: AND (pbc.balance_sequence = 1
1601: or (pbc.code=4005 and pbc.balance_sequence=2)
1602: ) ;

Line 2170: , p_start_period_id IN per_time_periods.time_period_id%TYPE

2166: -- processed assignment balance value information
2167: -------------------------------------------------------------------------------
2168: PROCEDURE pre_process_01032009 (
2169: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
2170: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2171: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2172: , p_include IN VARCHAR2
2173: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2174: , p_retrieve_ptd IN VARCHAR2

Line 2171: , p_end_period_id IN per_time_periods.time_period_id%TYPE

2167: -------------------------------------------------------------------------------
2168: PROCEDURE pre_process_01032009 (
2169: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
2170: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2171: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2172: , p_include IN VARCHAR2
2173: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
2174: , p_retrieve_ptd IN VARCHAR2
2175: , p_retrieve_mtd IN VARCHAR2

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

2175: , p_retrieve_mtd IN VARCHAR2
2176: , p_retrieve_ytd IN VARCHAR2
2177: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
2178: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
2179: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
2180: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
2181: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
2182: , p_tot_employees OUT NOCOPY NUMBER
2183: , p_tot_assignments OUT NOCOPY NUMBER

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

2176: , p_retrieve_ytd IN VARCHAR2
2177: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
2178: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
2179: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
2180: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
2181: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
2182: , p_tot_employees OUT NOCOPY NUMBER
2183: , p_tot_assignments OUT NOCOPY NUMBER
2184: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804

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

2177: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
2178: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
2179: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
2180: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
2181: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
2182: , p_tot_employees OUT NOCOPY NUMBER
2183: , p_tot_assignments OUT NOCOPY NUMBER
2184: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804
2185: )

Line 2197: , p_start_period_id IN per_time_periods.time_period_id%TYPE

2193: -----------------------------------------------------------------
2194: -- Bug 5330452
2195: CURSOR csr_processed_assignments (
2196: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
2197: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2198: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2199: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
2200: )
2201: IS

Line 2198: , p_end_period_id IN per_time_periods.time_period_id%TYPE

2194: -- Bug 5330452
2195: CURSOR csr_processed_assignments (
2196: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
2197: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2198: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2199: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
2200: )
2201: IS
2202: SELECT

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

2219: , hr_organization_information oit
2220: , per_assignment_extra_info aei
2221: , per_assignments_f asg
2222: , per_people_f pap
2223: , (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id) ptp
2224: WHERE
2225: ppa.payroll_id = p_payroll_id
2226: AND ppa.time_period_id >= p_start_period_id
2227: AND ppa.time_period_id <= p_end_period_id

Line 2280: , p_start_period_id IN per_time_periods.time_period_id%TYPE

2276: CURSOR csr_irp5_balances (
2277: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
2278: p_action_seq IN pay_assignment_actions.action_sequence%TYPE
2279: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
2280: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2281: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2282: )
2283: IS
2284: SELECT DISTINCT

Line 2281: , p_end_period_id IN per_time_periods.time_period_id%TYPE

2277: -- p_asg_action_id IN pay_assignment_actions.assignment_action_id%TYPE
2278: p_action_seq IN pay_assignment_actions.action_sequence%TYPE
2279: , p_asg_id IN pay_assignment_actions.assignment_id%TYPE
2280: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2281: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2282: )
2283: IS
2284: SELECT DISTINCT
2285: pbc.balance_name bal_name

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

2298: AND prr.assignment_action_id = paa.assignment_action_id
2299: AND paa.assignment_id = p_asg_id
2300: AND ppa.payroll_action_id = paa.payroll_action_id
2301: AND ppa.action_type IN ('R', 'I', 'B', 'Q', 'V')
2302: AND ppa.effective_date >= (select start_date from per_time_periods ptp where ptp.time_period_id = p_start_period_id)
2303: AND ppa.effective_date <= (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id)
2304: AND pbc.balance_type_id = feed.balance_type_id
2305: AND (pbc.balance_sequence = 1
2306: or (pbc.code=4005 and pbc.balance_sequence=2)

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

2299: AND paa.assignment_id = p_asg_id
2300: AND ppa.payroll_action_id = paa.payroll_action_id
2301: AND ppa.action_type IN ('R', 'I', 'B', 'Q', 'V')
2302: AND ppa.effective_date >= (select start_date from per_time_periods ptp where ptp.time_period_id = p_start_period_id)
2303: AND ppa.effective_date <= (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id)
2304: AND pbc.balance_type_id = feed.balance_type_id
2305: AND (pbc.balance_sequence = 1
2306: or (pbc.code=4005 and pbc.balance_sequence=2)
2307: )

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

2326: AND prr.assignment_action_id = paa.assignment_action_id
2327: AND paa.assignment_id = p_asg_id
2328: AND ppa.payroll_action_id = paa.payroll_action_id
2329: AND ppa.action_type IN ('R', 'I', 'B', 'Q', 'V')
2330: AND ppa.effective_date >= (select start_date from per_time_periods ptp where ptp.time_period_id = p_start_period_id)
2331: AND ppa.effective_date <= (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id)
2332: AND pbt.balance_type_id = feed.balance_type_id
2333: AND pbt.balance_name in ('Skills Levy','UIF Employee Contribution','UIF Employer Contribution')
2334: AND pbt.legislation_code='ZA';

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

2327: AND paa.assignment_id = p_asg_id
2328: AND ppa.payroll_action_id = paa.payroll_action_id
2329: AND ppa.action_type IN ('R', 'I', 'B', 'Q', 'V')
2330: AND ppa.effective_date >= (select start_date from per_time_periods ptp where ptp.time_period_id = p_start_period_id)
2331: AND ppa.effective_date <= (select end_date from per_time_periods ptp where ptp.time_period_id = p_end_period_id)
2332: AND pbt.balance_type_id = feed.balance_type_id
2333: AND pbt.balance_name in ('Skills Levy','UIF Employee Contribution','UIF Employer Contribution')
2334: AND pbt.legislation_code='ZA';
2335: /*

Line 2940: , p_start_period_id IN per_time_periods.time_period_id%TYPE

2936: -- bug 13444804
2937:
2938: PROCEDURE archive_set_globals (
2939: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
2940: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2941: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2942: , p_include IN VARCHAR2
2943: , p_retrieve_ptd IN VARCHAR2
2944: , p_retrieve_mtd IN VARCHAR2

Line 2941: , p_end_period_id IN per_time_periods.time_period_id%TYPE

2937:
2938: PROCEDURE archive_set_globals (
2939: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
2940: , p_start_period_id IN per_time_periods.time_period_id%TYPE
2941: , p_end_period_id IN per_time_periods.time_period_id%TYPE
2942: , p_include IN VARCHAR2
2943: , p_retrieve_ptd IN VARCHAR2
2944: , p_retrieve_mtd IN VARCHAR2
2945: , p_retrieve_ytd IN VARCHAR2