DBA Data[Home] [Help]

APPS.PAY_AU_FOREIGN_WORKERS dependencies on PAY_PAYROLL_ACTIONS

Line 1045: pay_payroll_actions ppa,

1041: IS
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

Line 1072: pay_payroll_actions ppa,

1068: IS
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