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_ALL_ASSIGNMENTS_F

Line 470: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

466: -------------------------------------------------------------------------------
467: FUNCTION run_result_value (
468: p_element_name IN pay_element_types_f.element_name%TYPE
469: , p_value_name IN pay_input_values_f.name%TYPE
470: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
471: , p_run_result_id IN OUT NOCOPY pay_run_results.run_result_id%TYPE
472: )
473: RETURN pay_run_result_values.result_value%TYPE
474: AS

Line 638: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

634: -------------------------------------------------------------------------------
635: -- assignment_tax_status_directive
636: -------------------------------------------------------------------------------
637: PROCEDURE assignment_tax_sta_dir (
638: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
639: , p_asg_tax_status OUT NOCOPY hr_lookups.meaning%TYPE
640: , p_asg_dir_value OUT NOCOPY pay_run_result_values.result_value%TYPE
641: , p_asg_tax_status_code OUT NOCOPY hr_lookups.lookup_code%TYPE
642: )

Line 704: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

700: -------------------------------------------------------------------------------
701: -- assignment_nature
702: -------------------------------------------------------------------------------
703: PROCEDURE assignment_nature (
704: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
705: , p_effective_date IN DATE
706: , p_asg_nature OUT NOCOPY hr_lookups.meaning%TYPE
707: )
708: AS

Line 717: c_assignment_id IN per_all_assignments_f.assignment_id%TYPE

713: -----------------------------------------------------------------
714: -- Cursor csr_asg_nature
715: -----------------------------------------------------------------
716: CURSOR csr_asg_nature (
717: c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
718: , c_effective_date IN DATE
719: )
720: IS
721: SELECT

Line 724: per_all_assignments_f ass

720: IS
721: SELECT
722: nvl(fcl.meaning, 'A') nature
723: FROM
724: per_all_assignments_f ass
725: , per_assignment_extra_info aei
726: , fnd_lookup_values fcl
727: WHERE ass.assignment_id = c_assignment_id
728: AND ass.effective_start_date =

Line 731: FROM per_all_assignments_f paf2

727: WHERE ass.assignment_id = c_assignment_id
728: AND ass.effective_start_date =
729: (
730: SELECT max(paf2.effective_start_date)
731: FROM per_all_assignments_f paf2
732: WHERE paf2.assignment_id = ass.assignment_id
733: AND paf2.effective_start_date <= c_effective_date
734: )
735: AND ass.assignment_id = aei.assignment_id(+)

Line 830: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

826: -------------------------------------------------------------------------------
827: -- assignment_start_date
828: -------------------------------------------------------------------------------
829: FUNCTION assignment_start_date (
830: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
831: )
832: RETURN DATE AS
833: ---------
834: -- Cursor

Line 839: FROM per_all_assignments_f per

835: ---------
836: CURSOR csr_assignment_start_date
837: IS
838: SELECT MIN(per.effective_start_date)
839: FROM per_all_assignments_f per
840: , per_assignment_status_types past
841: WHERE per.assignment_id = p_assignment_id
842: AND per.assignment_status_type_id = past.assignment_status_type_id
843: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 849: l_date per_all_assignments_f.effective_start_date%TYPE;

845: ------------
846: -- Variables
847: ------------
848: /* DEFAULT ;*/
849: l_date per_all_assignments_f.effective_start_date%TYPE;
850: -------------------------------------------------------------------------------
851: BEGIN -- MAIN --
852: -------------------------------------------------------------------------------
853: hr_utility.set_location('py_za_tax_reg.assignment_start_date',1);

Line 873: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

869: -------------------------------------------------------------------------------
870: -- assignment_end_date
871: -------------------------------------------------------------------------------
872: FUNCTION assignment_end_date (
873: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
874: )
875: RETURN DATE AS
876: ---------
877: -- Cursor

Line 882: FROM per_all_assignments_f per

878: ---------
879: CURSOR csr_assignment_end_date
880: IS
881: SELECT MAX(per.effective_end_date)
882: FROM per_all_assignments_f per
883: , per_assignment_status_types past
884: WHERE per.assignment_id = p_assignment_id
885: AND per.assignment_status_type_id = past.assignment_status_type_id
886: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 892: l_date per_all_assignments_f.effective_start_date%TYPE;

888: ------------
889: -- Variables
890: ------------
891: /* DEFAULT ;*/
892: l_date per_all_assignments_f.effective_start_date%TYPE;
893: -------------------------------------------------------------------------------
894: BEGIN -- MAIN --
895: -------------------------------------------------------------------------------
896: hr_utility.set_location('py_za_tax_reg.assignment_end_date',1);

Line 917: p_asg_id IN per_all_assignments_f.assignment_id%TYPE

913: -------------------------------------------------------------------------------
914: -- include_assignment
915: -------------------------------------------------------------------------------
916: FUNCTION include_assignment (
917: p_asg_id IN per_all_assignments_f.assignment_id%TYPE
918: , p_asg_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
919: , p_asg_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
920: )
921: RETURN BOOLEAN AS

Line 918: , p_asg_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

914: -- include_assignment
915: -------------------------------------------------------------------------------
916: FUNCTION include_assignment (
917: p_asg_id IN per_all_assignments_f.assignment_id%TYPE
918: , p_asg_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
919: , p_asg_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
920: )
921: RETURN BOOLEAN AS
922: ------------

Line 919: , p_asg_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

915: -------------------------------------------------------------------------------
916: FUNCTION include_assignment (
917: p_asg_id IN per_all_assignments_f.assignment_id%TYPE
918: , p_asg_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
919: , p_asg_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
920: )
921: RETURN BOOLEAN AS
922: ------------
923: -- Variables

Line 925: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;

921: RETURN BOOLEAN AS
922: ------------
923: -- Variables
924: ------------
925: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
926: l_include BOOLEAN;
927: --
928: -------------------------------------------------------------------------------
929: BEGIN -- MAIN --

Line 998: p_asg_id IN per_all_assignments_f.assignment_id%TYPE

994: -- This function is the overloaded version of include_assignment
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

Line 1006: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;

1002: RETURN VARCHAR2 AS
1003: ------------
1004: -- Variables
1005: ------------
1006: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
1007: l_include VARCHAR2(1);
1008: --
1009: -------------------------------------------------------------------------------
1010: BEGIN -- MAIN --

Line 1470: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

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
1473: , p_retrieve_ytd IN VARCHAR2
1474: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE

Line 1496: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

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
1500: paa.assignment_action_id

Line 1606: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;

1602: ) ;
1603: ------------
1604: -- Variables
1605: ------------
1606: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
1607: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
1608: l_asg_tax_status pay_run_result_values.result_value%TYPE;
1609: l_asg_dir_value pay_run_result_values.result_value%TYPE;
1610: l_asg_dys_worked NUMBER;

Line 1607: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;

1603: ------------
1604: -- Variables
1605: ------------
1606: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
1607: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
1608: l_asg_tax_status pay_run_result_values.result_value%TYPE;
1609: l_asg_dir_value pay_run_result_values.result_value%TYPE;
1610: l_asg_dys_worked NUMBER;
1611: l_ptd_bal NUMBER;

Line 1904: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1900: -------------------------------------------------------------------------------
1901: -- assignment_nature to be used from tax year 2010 onwards
1902: -------------------------------------------------------------------------------
1903: PROCEDURE assignment_nature_01032009 (
1904: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1905: , p_effective_date IN DATE
1906: , p_asg_nature OUT NOCOPY hr_lookups.meaning%TYPE
1907: , p_foreign_income OUT NOCOPY varchar2
1908: )

Line 1918: c_assignment_id IN per_all_assignments_f.assignment_id%TYPE

1914: -----------------------------------------------------------------
1915: -- Cursor csr_asg_nature
1916: -----------------------------------------------------------------
1917: CURSOR csr_asg_nature (
1918: c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1919: , c_effective_date IN DATE
1920: )
1921: IS
1922: SELECT

Line 1926: per_all_assignments_f ass

1922: SELECT
1923: nvl(fcl.meaning, 'A') nature,
1924: aei.aei_information15 foreign_income
1925: FROM
1926: per_all_assignments_f ass
1927: , per_assignment_extra_info aei
1928: , fnd_lookup_values fcl
1929: WHERE ass.assignment_id = c_assignment_id
1930: AND ass.effective_start_date =

Line 1933: FROM per_all_assignments_f paf2

1929: WHERE ass.assignment_id = c_assignment_id
1930: AND ass.effective_start_date =
1931: (
1932: SELECT max(paf2.effective_start_date)
1933: FROM per_all_assignments_f paf2
1934: WHERE paf2.assignment_id = ass.assignment_id
1935: AND paf2.effective_start_date <= c_effective_date
1936: )
1937: AND ass.assignment_id = aei.assignment_id(+)

Line 2173: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

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
2176: , p_retrieve_ytd IN VARCHAR2
2177: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE

Line 2199: , p_asg_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

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
2203: paa.assignment_action_id

Line 2382: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;

2378:
2379: ------------
2380: -- Variables
2381: ------------
2382: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
2383: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
2384: l_asg_tax_status pay_run_result_values.result_value%TYPE;
2385: l_asg_dir_value pay_run_result_values.result_value%TYPE;
2386: l_asg_dys_worked NUMBER;

Line 2383: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;

2379: ------------
2380: -- Variables
2381: ------------
2382: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
2383: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
2384: l_asg_tax_status pay_run_result_values.result_value%TYPE;
2385: l_asg_dir_value pay_run_result_values.result_value%TYPE;
2386: l_asg_dys_worked NUMBER;
2387: l_ptd_bal NUMBER;