APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_POPULATION_RANGES

Line 873: pay_population_ranges ppr

869: ppa.effective_date effective_end_date
870: FROM per_all_assignments_f ASG,
871: pay_assignment_actions paa,
872: pay_payroll_actions ppa,
873: pay_population_ranges ppr
874: WHERE ppa.effective_date between l_period_start
875: and l_period_end
876: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
877: and paa.payroll_action_id = ppa.payroll_action_id

Line 950: pay_population_ranges ppr

946: ppa.effective_date effective_end_date
947: FROM per_all_assignments_f ASG,
948: pay_assignment_actions paa,
949: pay_payroll_actions ppa,
950: pay_population_ranges ppr
951: WHERE ppa.effective_date between l_period_start
952: and l_period_end
953: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
954: and paa.payroll_action_id = ppa.payroll_action_id

Line 1029: pay_population_ranges ppr

1025: ppa.effective_date effective_end_date
1026: FROM per_all_assignments_f ASG,
1027: pay_assignment_actions paa,
1028: pay_payroll_actions ppa,
1029: pay_population_ranges ppr
1030: WHERE ppa.effective_date between l_period_start
1031: and l_period_end
1032: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1033: and paa.payroll_action_id = ppa.payroll_action_id

Line 1116: pay_population_ranges ppr

1112: FROM per_all_assignments_f ASG,
1113: pay_assignment_actions paa,
1114: pay_payroll_actions ppa,
1115: hr_organization_information HOI_PR,
1116: pay_population_ranges ppr
1117: WHERE ppa.effective_date between l_period_start and l_period_end
1118: AND ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1119: AND paa.payroll_action_id = ppa.payroll_action_id
1120: AND hoi_pr.organization_id = paa.tax_unit_id