DBA Data[Home] [Help]

APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PER_TIME_PERIODS

Line 1008: per_time_periods ptp

1004: pay_assignment_actions paa_run,
1005: pay_action_interlocks pai_run,
1006: pay_payroll_actions ppa_pre,
1007: pay_payroll_actions ppa_run,
1008: per_time_periods ptp
1009: where paa_arch_mst.assignment_action_id = p_master_aa_id
1010: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
1011: and paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id
1012: and paa_arch_chd.assignment_id = paa_arch_mst.assignment_id

Line 1040: per_time_periods ptp,

1036: IS
1037: SELECT pps.actual_termination_date
1038: FROM pay_payroll_actions ppa,
1039: pay_assignment_actions paa,
1040: per_time_periods ptp,
1041: per_all_assignments_f paf,
1042: per_periods_of_service pps
1043: WHERE paa.assignment_action_id = p_assignment_action_id
1044: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1142: , p_time_period_id => csr_rec.time_period_id -- time_period_id from per_time_periods

1138: , p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id -- prepayment assignment_action_id
1139: , p_date_earned => csr_rec.run_date_earned -- payroll date_earned
1140: , p_latest_period_end_date => l_payment_date -- latest payment date
1141: , p_run_effective_date => csr_rec.run_effective_date -- run effective Date
1142: , p_time_period_id => csr_rec.time_period_id -- time_period_id from per_time_periods
1143: , p_pre_effective_date => csr_rec.pre_effective_date
1144: -- prepayment effective date, bug 5736815
1145: );
1146: