DBA Data[Home] [Help]

APPS.PAY_CA_RL1_REG dependencies on PAY_POPULATION_RANGES

Line 334: pay_population_ranges ppr

330: select distinct to_number(paa.serial_number),
331: paa.assignment_id assignment_id
332: from pay_payroll_actions ppa,
333: pay_assignment_actions paa,
334: pay_population_ranges ppr
335: where ppa.report_type = 'RL1'
336: and ppa.report_qualifier = 'CAEOYRL1'
337: and ppa.report_category = 'CAEOYRL1'
338: and ppa.effective_date = l_year_end

Line 378: pay_population_ranges ppr

374: select distinct to_number(paa.serial_number),
375: paa.assignment_id assignment_id
376: from pay_payroll_actions ppa,
377: pay_assignment_actions paa,
378: pay_population_ranges ppr
379: where ppa.report_type = 'RL1'
380: and ppa.report_qualifier = 'CAEOYRL1'
381: and ppa.report_category = 'CAEOYRL1'
382: and ppa.effective_date = l_year_end

Line 431: pay_population_ranges ppr

427: select distinct to_number(paa.serial_number),
428: paa.assignment_id assignment_id
429: from pay_payroll_actions ppa,
430: pay_assignment_actions paa,
431: pay_population_ranges ppr
432: where ppa.report_type = 'RL1'
433: and ppa.report_qualifier = 'CAEOYRL1'
434: and ppa.report_category = 'CAEOYRL1'
435: and ppa.effective_date = l_year_end