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_FOREIGN_WORKERS dependencies on PER_TIME_PERIODS

Line 764: ,p_payroll_id IN per_time_periods.payroll_id%TYPE

760: */
761:
762: FUNCTION is_le_changed(p_assignment_id IN per_assignments_f.assignment_id%TYPE
763: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
764: ,p_payroll_id IN per_time_periods.payroll_id%TYPE
765: ,p_time_period_id IN per_time_periods.time_period_id%TYPE)
766: RETURN VARCHAR2
767: IS
768:

Line 765: ,p_time_period_id IN per_time_periods.time_period_id%TYPE)

761:
762: FUNCTION is_le_changed(p_assignment_id IN per_assignments_f.assignment_id%TYPE
763: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
764: ,p_payroll_id IN per_time_periods.payroll_id%TYPE
765: ,p_time_period_id IN per_time_periods.time_period_id%TYPE)
766: RETURN VARCHAR2
767: IS
768:
769: CURSOR other_le_exists(c_assignment_id per_assignments_f.assignment_id%TYPE

Line 771: ,c_payroll_id per_time_periods.payroll_id%TYPE

767: IS
768:
769: CURSOR other_le_exists(c_assignment_id per_assignments_f.assignment_id%TYPE
770: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
771: ,c_payroll_id per_time_periods.payroll_id%TYPE
772: ,c_time_period_id per_time_periods.time_period_id%TYPE)
773: IS
774: SELECT 'Y'
775: FROM DUAL

Line 772: ,c_time_period_id per_time_periods.time_period_id%TYPE)

768:
769: CURSOR other_le_exists(c_assignment_id per_assignments_f.assignment_id%TYPE
770: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
771: ,c_payroll_id per_time_periods.payroll_id%TYPE
772: ,c_time_period_id per_time_periods.time_period_id%TYPE)
773: IS
774: SELECT 'Y'
775: FROM DUAL
776: WHERE EXISTS

Line 780: ,per_time_periods ptp

776: WHERE EXISTS
777: ( SELECT '1'
778: FROM per_assignments_f paf
779: ,hr_soft_coding_keyflex hsc
780: ,per_time_periods ptp
781: WHERE ptp.payroll_id = c_payroll_id
782: AND ptp.time_period_id = c_time_period_id
783: AND paf.assignment_id = c_assignment_id
784: AND paf.effective_start_date <= ptp.end_date

Line 846: ,p_payroll_id IN per_time_periods.payroll_id%TYPE

842: */
843:
844: FUNCTION get_le_changed_prorate_factor(p_assignment_id IN per_assignments_f.assignment_id%TYPE
845: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
846: ,p_payroll_id IN per_time_periods.payroll_id%TYPE
847: ,p_time_period_id IN per_time_periods.time_period_id%TYPE
848: ,p_fw_type IN VARCHAR2
849: )
850: RETURN NUMBER

Line 847: ,p_time_period_id IN per_time_periods.time_period_id%TYPE

843:
844: FUNCTION get_le_changed_prorate_factor(p_assignment_id IN per_assignments_f.assignment_id%TYPE
845: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
846: ,p_payroll_id IN per_time_periods.payroll_id%TYPE
847: ,p_time_period_id IN per_time_periods.time_period_id%TYPE
848: ,p_fw_type IN VARCHAR2
849: )
850: RETURN NUMBER
851: IS

Line 855: ,c_payroll_id per_time_periods.payroll_id%TYPE

851: IS
852:
853: CURSOR le_at_period_end(c_assignment_id per_assignments_f.assignment_id%TYPE
854: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
855: ,c_payroll_id per_time_periods.payroll_id%TYPE
856: ,c_time_period_id per_time_periods.time_period_id%TYPE)
857: IS
858: SELECT 'Y'
859: FROM DUAL

Line 856: ,c_time_period_id per_time_periods.time_period_id%TYPE)

852:
853: CURSOR le_at_period_end(c_assignment_id per_assignments_f.assignment_id%TYPE
854: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
855: ,c_payroll_id per_time_periods.payroll_id%TYPE
856: ,c_time_period_id per_time_periods.time_period_id%TYPE)
857: IS
858: SELECT 'Y'
859: FROM DUAL
860: WHERE EXISTS

Line 864: ,per_time_periods ptp

860: WHERE EXISTS
861: ( SELECT '1'
862: FROM per_assignments_f paf
863: ,hr_soft_coding_keyflex hsc
864: ,per_time_periods ptp
865: WHERE ptp.payroll_id = c_payroll_id
866: AND ptp.time_period_id = c_time_period_id
867: AND paf.assignment_id = c_assignment_id
868: AND ptp.end_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 875: ,c_payroll_id per_time_periods.payroll_id%TYPE

871: );
872:
873: CURSOR get_fw_days(c_assignment_id per_assignments_f.assignment_id%TYPE
874: ,c_status_id per_assignment_status_types.assignment_status_type_id%TYPE
875: ,c_payroll_id per_time_periods.payroll_id%TYPE
876: ,c_time_period_id per_time_periods.time_period_id%TYPE)
877: IS
878: SELECT ptp.time_period_id
879: ,GREATEST(paf.effective_start_date,ptp.start_date) prorate_start

Line 876: ,c_time_period_id per_time_periods.time_period_id%TYPE)

872:
873: CURSOR get_fw_days(c_assignment_id per_assignments_f.assignment_id%TYPE
874: ,c_status_id per_assignment_status_types.assignment_status_type_id%TYPE
875: ,c_payroll_id per_time_periods.payroll_id%TYPE
876: ,c_time_period_id per_time_periods.time_period_id%TYPE)
877: IS
878: SELECT ptp.time_period_id
879: ,GREATEST(paf.effective_start_date,ptp.start_date) prorate_start
880: ,LEAST(paf.effective_end_date,ptp.end_date) prorate_end

Line 882: ,per_time_periods ptp

878: SELECT ptp.time_period_id
879: ,GREATEST(paf.effective_start_date,ptp.start_date) prorate_start
880: ,LEAST(paf.effective_end_date,ptp.end_date) prorate_end
881: FROM per_assignments_f paf
882: ,per_time_periods ptp
883: WHERE paf.assignment_id = c_assignment_id
884: AND ptp.payroll_id = c_payroll_id
885: AND ptp.time_period_id = c_time_period_id
886: AND paf.assignment_status_type_id = c_status_id

Line 1024: ,per_time_periods ptp

1020: ,ptp.end_date
1021: ,ptp.payroll_id
1022: ,pay_au_foreign_workers.is_le_changed(c_assignment_id,p_tax_unit_id,ptp.payroll_id,ptp.time_period_id) le_change_flag
1023: FROM per_assignments_f paf
1024: ,per_time_periods ptp
1025: WHERE paf.assignment_id = c_assignment_id
1026: AND c_fw_end_date BETWEEN paf.effective_start_date AND paf.effective_end_date
1027: AND paf.payroll_id = ptp.payroll_id
1028: AND ptp.start_date <= c_fw_end_date

Line 1036: ,c_time_period_id per_time_periods.time_period_id%TYPE

1032:
1033: /* Check cost - 13 on hr2rw102 - should be fine! */
1034: CURSOR csr_max_action_id
1035: (c_assignment_id per_assignments_f.assignment_id%TYPE
1036: ,c_time_period_id per_time_periods.time_period_id%TYPE
1037: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
1038: ,c_start_date DATE
1039: ,c_end_date DATE
1040: )

Line 1047: per_time_periods ptp

1043: -- ,MAX(paa.action_sequence) action_sequence
1044: FROM pay_assignment_actions paa,
1045: pay_payroll_actions ppa,
1046: per_assignments_f paf,
1047: per_time_periods ptp
1048: WHERE paa.assignment_id = paf.assignment_id
1049: AND paf.assignment_id = c_assignment_id
1050: AND ppa.payroll_action_id = paa.payroll_action_id
1051: AND ppa.effective_date BETWEEN c_start_date AND c_end_date /* Join Ensures I pick Ass Act within year only */