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_ASSIGNMENTS_F

Line 217: (c_assignment_id per_assignments_f.assignment_id%TYPE

213: ,p_fw_type IN VARCHAR2)
214: RETURN VARCHAR2
215: IS
216: CURSOR is_foreign_worker
217: (c_assignment_id per_assignments_f.assignment_id%TYPE
218: ,c_start_date DATE
219: ,c_end_date DATE
220: ,c_tax_unit_id NUMBER
221: ,c_status_id NUMBER)

Line 227: FROM per_assignments_f paf

223: SELECT 'Y'
224: FROM DUAL
225: WHERE EXISTS
226: ( SELECT 1
227: FROM per_assignments_f paf
228: ,hr_soft_coding_keyflex hsc
229: WHERE paf.assignment_id = c_assignment_id
230: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
231: AND hsc.segment1 = c_tax_unit_id

Line 380: FUNCTION check_fw_terminated(p_assignment_id IN per_assignments_f.assignment_id%TYPE

376: Outputs : p_act_term_date - Actual Termination Date
377:
378: */
379:
380: FUNCTION check_fw_terminated(p_assignment_id IN per_assignments_f.assignment_id%TYPE
381: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
382: ,p_start_date IN DATE
383: ,p_end_date IN DATE
384: ,p_fw_type IN VARCHAR2

Line 390: (c_assignment_id per_assignments_f.assignment_id%TYPE

386: RETURN VARCHAR2
387: AS
388:
389: CURSOR is_fw_terminated
390: (c_assignment_id per_assignments_f.assignment_id%TYPE
391: ,c_tax_unit_id VARCHAR2
392: ,c_start_date DATE
393: ,c_end_date DATE
394: ,c_status_id per_assignments_f.assignment_status_type_id%TYPE)

Line 394: ,c_status_id per_assignments_f.assignment_status_type_id%TYPE)

390: (c_assignment_id per_assignments_f.assignment_id%TYPE
391: ,c_tax_unit_id VARCHAR2
392: ,c_start_date DATE
393: ,c_end_date DATE
394: ,c_status_id per_assignments_f.assignment_status_type_id%TYPE)
395: IS
396: SELECT pps.actual_termination_date
397: FROM per_assignments_f paf
398: ,hr_soft_coding_keyflex hsc

Line 397: FROM per_assignments_f paf

393: ,c_end_date DATE
394: ,c_status_id per_assignments_f.assignment_status_type_id%TYPE)
395: IS
396: SELECT pps.actual_termination_date
397: FROM per_assignments_f paf
398: ,hr_soft_coding_keyflex hsc
399: ,per_periods_of_service pps
400: WHERE paf.assignment_id = c_assignment_id
401: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id

Line 481: PROCEDURE get_foreign_worker_dates (p_assignment_id IN per_assignments_f.assignment_id%TYPE

477: contains Assignment Details
478:
479: */
480:
481: PROCEDURE get_foreign_worker_dates (p_assignment_id IN per_assignments_f.assignment_id%TYPE
482: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
483: ,p_start_date IN DATE
484: ,p_end_date IN DATE
485: ,p_fw_type IN VARCHAR2

Line 490: (c_assignment_id per_assignments_f.assignment_id%TYPE

486: ,p_tab_fw_dates OUT NOCOPY pay_au_foreign_workers.tab_fw_dates)
487: AS
488:
489: CURSOR get_fw_asg_dates
490: (c_assignment_id per_assignments_f.assignment_id%TYPE
491: ,c_tax_unit_id VARCHAR2
492: ,c_start_date DATE
493: ,c_end_date DATE
494: ,c_status_id VARCHAR2)

Line 501: FROM per_assignments_f paf

497: ,paf.effective_start_date
498: ,paf.effective_end_date
499: ,paf.payroll_id
500: ,hsc.segment1 tax_unit_id
501: FROM per_assignments_f paf
502: ,hr_soft_coding_keyflex hsc
503: WHERE paf.assignment_id = c_assignment_id
504: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
505: AND hsc.segment1 LIKE c_tax_unit_id

Line 762: FUNCTION is_le_changed(p_assignment_id IN per_assignments_f.assignment_id%TYPE

758: Outputs : 'Y'/'N' - Employee has more than one LE, then 'Y' else 'N'
759:
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

Line 769: CURSOR other_le_exists(c_assignment_id per_assignments_f.assignment_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
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

Line 778: FROM per_assignments_f paf

774: SELECT 'Y'
775: FROM DUAL
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

Line 844: FUNCTION get_le_changed_prorate_factor(p_assignment_id IN per_assignments_f.assignment_id%TYPE

840: Outputs : Number - Number of days to be taken for proration
841:
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

Line 853: CURSOR le_at_period_end(c_assignment_id per_assignments_f.assignment_id%TYPE

849: )
850: RETURN NUMBER
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

Line 862: FROM per_assignments_f paf

858: SELECT 'Y'
859: FROM DUAL
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

Line 873: CURSOR get_fw_days(c_assignment_id per_assignments_f.assignment_id%TYPE

869: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
870: AND hsc.segment1 = c_tax_unit_id
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

Line 881: FROM per_assignments_f paf

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
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

Line 986: PROCEDURE get_foreign_payment_amounts(p_assignment_id IN per_assignments_f.assignment_id%TYPE

982: contains Balance Values
983:
984: */
985:
986: PROCEDURE get_foreign_payment_amounts(p_assignment_id IN per_assignments_f.assignment_id%TYPE
987: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
988: ,p_tab_fw_dates IN pay_au_foreign_workers.tab_fw_dates
989: ,p_start_date IN DATE
990: ,p_end_date IN DATE

Line 1009: CURSOR csr_get_period_prorate(c_assignment_id per_assignments_f.assignment_id%TYPE

1005:
1006: TYPE prorate_tab IS TABLE OF prorate_dat INDEX BY BINARY_INTEGER;
1007:
1008: /* Cost 7 on hr2rw102 */
1009: CURSOR csr_get_period_prorate(c_assignment_id per_assignments_f.assignment_id%TYPE
1010: ,c_fw_start_date DATE
1011: ,c_fw_end_date DATE
1012: ,c_start_date DATE
1013: ,c_end_date DATE)

Line 1023: FROM per_assignments_f paf

1019: ,ptp.start_date
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

Line 1035: (c_assignment_id per_assignments_f.assignment_id%TYPE

1031: AND ptp.end_date >= c_start_date;
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

Line 1046: per_assignments_f paf,

1042: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
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

Line 1063: (c_assignment_id per_assignments_f.assignment_id%TYPE

1059:
1060:
1061: /* Check cost - 13 on hr2rw102 - should be fine! */
1062: CURSOR csr_ytd_max_action_id
1063: (c_assignment_id per_assignments_f.assignment_id%TYPE
1064: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
1065: ,c_start_date DATE
1066: ,c_end_date DATE
1067: )

Line 1073: per_assignments_f paf

1069: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1070: -- ,MAX(paa.action_sequence) action_sequence
1071: FROM pay_assignment_actions paa,
1072: pay_payroll_actions ppa,
1073: per_assignments_f paf
1074: WHERE paa.assignment_id = paf.assignment_id
1075: AND paf.assignment_id = c_assignment_id
1076: AND ppa.payroll_action_id = paa.payroll_action_id
1077: AND ppa.effective_date BETWEEN c_start_date AND c_end_date /* Join Ensures I pick Ass Act within year only */