DBA Data[Home] [Help]

APPS.PAY_PYR_BUS dependencies on DUAL

Line 597: SELECT 'y' from dual where exists

593: l_dummy VARCHAR2(1);
594: l_api_updating BOOLEAN;
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

Line 615: select 'Y' from dual where exists

611: and pyr1.rate_id=p_rate_id
612: and pyr1.rate_id <> pyr2.rate_id);
613: --
614: cursor csr_price_differentials is
615: select 'Y' from dual where exists
616: (SELECT 'Y'
617: FROM fnd_lookups
618: WHERE lookup_type='PRICE DIFFERENTIALS'
619: AND lookup_code=p_asg_rate_type