APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_POPULATION_RANGES

Line 803: pay_population_ranges ppr

799: ppa.effective_date effective_end_date
800: FROM per_all_assignments_f ASG,
801: pay_assignment_actions paa,
802: pay_payroll_actions ppa,
803: pay_population_ranges ppr
804: WHERE ppa.effective_date between l_period_start
805: and l_period_end
806: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
807: and paa.payroll_action_id = ppa.payroll_action_id

Line 880: pay_population_ranges ppr

876: ppa.effective_date effective_end_date
877: FROM per_all_assignments_f ASG,
878: pay_assignment_actions paa,
879: pay_payroll_actions ppa,
880: pay_population_ranges ppr
881: WHERE ppa.effective_date between l_period_start
882: and l_period_end
883: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
884: and paa.payroll_action_id = ppa.payroll_action_id

Line 959: pay_population_ranges ppr

955: ppa.effective_date effective_end_date
956: FROM per_all_assignments_f ASG,
957: pay_assignment_actions paa,
958: pay_payroll_actions ppa,
959: pay_population_ranges ppr
960: WHERE ppa.effective_date between l_period_start
961: and l_period_end
962: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
963: and paa.payroll_action_id = ppa.payroll_action_id

Line 1046: pay_population_ranges ppr

1042: FROM per_all_assignments_f ASG,
1043: pay_assignment_actions paa,
1044: pay_payroll_actions ppa,
1045: hr_organization_information HOI_PR,
1046: pay_population_ranges ppr
1047: WHERE ppa.effective_date between l_period_start and l_period_end
1048: AND ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1049: AND paa.payroll_action_id = ppa.payroll_action_id
1050: AND hoi_pr.organization_id = paa.tax_unit_id