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 413: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

409: -------------------------------------------------------------------------------
410: FUNCTION run_result_value (
411: p_element_name IN pay_element_types_f.element_name%TYPE
412: , p_value_name IN pay_input_values_f.name%TYPE
413: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
414: , p_run_result_id IN OUT NOCOPY pay_run_results.run_result_id%TYPE
415: )
416: RETURN pay_run_result_values.result_value%TYPE
417: AS

Line 581: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

577: -------------------------------------------------------------------------------
578: -- assignment_tax_status_directive
579: -------------------------------------------------------------------------------
580: PROCEDURE assignment_tax_sta_dir (
581: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
582: , p_asg_tax_status OUT NOCOPY hr_lookups.meaning%TYPE
583: , p_asg_dir_value OUT NOCOPY pay_run_result_values.result_value%TYPE
584: , p_asg_tax_status_code OUT NOCOPY hr_lookups.lookup_code%TYPE
585: )

Line 647: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

643: -------------------------------------------------------------------------------
644: -- assignment_nature
645: -------------------------------------------------------------------------------
646: PROCEDURE assignment_nature (
647: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
648: , p_effective_date IN DATE
649: , p_asg_nature OUT NOCOPY hr_lookups.meaning%TYPE
650: )
651: AS

Line 660: c_assignment_id IN per_all_assignments_f.assignment_id%TYPE

656: -----------------------------------------------------------------
657: -- Cursor csr_asg_nature
658: -----------------------------------------------------------------
659: CURSOR csr_asg_nature (
660: c_assignment_id IN per_all_assignments_f.assignment_id%TYPE
661: , c_effective_date IN DATE
662: )
663: IS
664: SELECT

Line 667: per_all_assignments_f ass

663: IS
664: SELECT
665: nvl(fcl.meaning, 'A') nature
666: FROM
667: per_all_assignments_f ass
668: , per_assignment_extra_info aei
669: , fnd_lookup_values fcl
670: WHERE ass.assignment_id = c_assignment_id
671: AND ass.effective_start_date =

Line 674: FROM per_all_assignments_f paf2

670: WHERE ass.assignment_id = c_assignment_id
671: AND ass.effective_start_date =
672: (
673: SELECT max(paf2.effective_start_date)
674: FROM per_all_assignments_f paf2
675: WHERE paf2.assignment_id = ass.assignment_id
676: AND paf2.effective_start_date <= c_effective_date
677: )
678: AND ass.assignment_id = aei.assignment_id(+)

Line 773: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

769: -------------------------------------------------------------------------------
770: -- assignment_start_date
771: -------------------------------------------------------------------------------
772: FUNCTION assignment_start_date (
773: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
774: )
775: RETURN DATE AS
776: ---------
777: -- Cursor

Line 782: FROM per_all_assignments_f per

778: ---------
779: CURSOR csr_assignment_start_date
780: IS
781: SELECT MIN(per.effective_start_date)
782: FROM per_all_assignments_f per
783: , per_assignment_status_types past
784: WHERE per.assignment_id = p_assignment_id
785: AND per.assignment_status_type_id = past.assignment_status_type_id
786: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 792: l_date per_all_assignments_f.effective_start_date%TYPE;

788: ------------
789: -- Variables
790: ------------
791: /* DEFAULT ;*/
792: l_date per_all_assignments_f.effective_start_date%TYPE;
793: -------------------------------------------------------------------------------
794: BEGIN -- MAIN --
795: -------------------------------------------------------------------------------
796: hr_utility.set_location('py_za_tax_reg.assignment_start_date',1);

Line 816: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

812: -------------------------------------------------------------------------------
813: -- assignment_end_date
814: -------------------------------------------------------------------------------
815: FUNCTION assignment_end_date (
816: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
817: )
818: RETURN DATE AS
819: ---------
820: -- Cursor

Line 825: FROM per_all_assignments_f per

821: ---------
822: CURSOR csr_assignment_end_date
823: IS
824: SELECT MAX(per.effective_end_date)
825: FROM per_all_assignments_f per
826: , per_assignment_status_types past
827: WHERE per.assignment_id = p_assignment_id
828: AND per.assignment_status_type_id = past.assignment_status_type_id
829: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 835: l_date per_all_assignments_f.effective_start_date%TYPE;

831: ------------
832: -- Variables
833: ------------
834: /* DEFAULT ;*/
835: l_date per_all_assignments_f.effective_start_date%TYPE;
836: -------------------------------------------------------------------------------
837: BEGIN -- MAIN --
838: -------------------------------------------------------------------------------
839: hr_utility.set_location('py_za_tax_reg.assignment_end_date',1);

Line 860: p_asg_id IN per_all_assignments_f.assignment_id%TYPE

856: -------------------------------------------------------------------------------
857: -- include_assignment
858: -------------------------------------------------------------------------------
859: FUNCTION include_assignment (
860: p_asg_id IN per_all_assignments_f.assignment_id%TYPE
861: , p_asg_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
862: , p_asg_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
863: )
864: RETURN BOOLEAN AS

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

857: -- include_assignment
858: -------------------------------------------------------------------------------
859: FUNCTION include_assignment (
860: p_asg_id IN per_all_assignments_f.assignment_id%TYPE
861: , p_asg_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
862: , p_asg_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
863: )
864: RETURN BOOLEAN AS
865: ------------

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

858: -------------------------------------------------------------------------------
859: FUNCTION include_assignment (
860: p_asg_id IN per_all_assignments_f.assignment_id%TYPE
861: , p_asg_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
862: , p_asg_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
863: )
864: RETURN BOOLEAN AS
865: ------------
866: -- Variables

Line 868: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;

864: RETURN BOOLEAN AS
865: ------------
866: -- Variables
867: ------------
868: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
869: l_include BOOLEAN;
870: --
871: -------------------------------------------------------------------------------
872: BEGIN -- MAIN --

Line 941: p_asg_id IN per_all_assignments_f.assignment_id%TYPE

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

Line 949: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;

945: RETURN VARCHAR2 AS
946: ------------
947: -- Variables
948: ------------
949: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
950: l_include VARCHAR2(1);
951: --
952: -------------------------------------------------------------------------------
953: BEGIN -- MAIN --

Line 1390: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

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

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

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

Line 1520: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;

1516: AND pbc.balance_sequence = 1;
1517: ------------
1518: -- Variables
1519: ------------
1520: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
1521: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
1522: l_asg_tax_status pay_run_result_values.result_value%TYPE;
1523: l_asg_dir_value pay_run_result_values.result_value%TYPE;
1524: l_asg_dys_worked NUMBER;

Line 1521: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;

1517: ------------
1518: -- Variables
1519: ------------
1520: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
1521: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
1522: l_asg_tax_status pay_run_result_values.result_value%TYPE;
1523: l_asg_dir_value pay_run_result_values.result_value%TYPE;
1524: l_asg_dys_worked NUMBER;
1525: l_ptd_bal NUMBER;