DBA Data[Home] [Help]

APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PER_TIME_PERIODS

Line 1007: per_time_periods ptp

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

Line 1039: per_time_periods ptp,

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

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

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