DBA Data[Home] [Help]

APPS.PAY_PYR_BUS dependencies on PAY_GRADE_RULES_F

Line 335: FROM pay_grade_rules_f pgr

331: ,p_rate_type IN pay_rates.rate_type%TYPE) IS
332: --
333: CURSOR chk_for_records IS
334: SELECT 'X'
335: FROM pay_grade_rules_f pgr
336: WHERE pgr.rate_id = p_rate_id;
337: --
338: l_proc VARCHAR2(72):= g_package || 'chk_for_child_records';
339: l_dummy CHAR;

Line 599: from pay_grade_rules_f pgr1

595: --
596: cursor csr_matching_children is
597: SELECT 'y' from dual where exists
598: (select 'y'
599: from pay_grade_rules_f pgr1
600: ,pay_grade_rules_f pgr2
601: ,pay_rates pyr1
602: ,pay_rates pyr2
603: where pgr1.rate_id=pyr1.rate_id

Line 600: ,pay_grade_rules_f pgr2

596: cursor csr_matching_children is
597: SELECT 'y' from dual where exists
598: (select 'y'
599: from pay_grade_rules_f pgr1
600: ,pay_grade_rules_f pgr2
601: ,pay_rates pyr1
602: ,pay_rates pyr2
603: where pgr1.rate_id=pyr1.rate_id
604: and pgr2.rate_id=pyr2.rate_id