APPS.PAY_PAYROLL_API dependencies on PAY_LEGISLATION_RULES

Line 564: cursor csr_soft_id_flex_num(c_legislation_code pay_legislation_rules.legislation_code%TYPE) is

560: where bg.business_group_id = c_business_group_id;
561:
562:
563: --Cursor for fetching the Soft coding structure id from the business group.
564: cursor csr_soft_id_flex_num(c_legislation_code pay_legislation_rules.legislation_code%TYPE) is
565: select lr.rule_mode
566: from pay_legislation_rules lr
567: where lr.legislation_code = c_legislation_code
568: and upper(lr.rule_type) = 'S';

Line 566: from pay_legislation_rules lr

562:
563: --Cursor for fetching the Soft coding structure id from the business group.
564: cursor csr_soft_id_flex_num(c_legislation_code pay_legislation_rules.legislation_code%TYPE) is
565: select lr.rule_mode
566: from pay_legislation_rules lr
567: where lr.legislation_code = c_legislation_code
568: and upper(lr.rule_type) = 'S';
569:
570: --Cursor for checking whether the given Cost Keyflex id is there or not

Line 1766: cursor csr_soft_id_flex_num(c_legislation_code pay_legislation_rules.legislation_code%TYPE ) is

1762:
1763: --
1764: --Cursor for getting the Soft coding structure id from business group id.
1765: --
1766: cursor csr_soft_id_flex_num(c_legislation_code pay_legislation_rules.legislation_code%TYPE ) is
1767: select lr.rule_mode
1768: from pay_legislation_rules lr
1769: where lr.legislation_code = c_legislation_code
1770: and upper(lr.rule_type) = 'S';

Line 1768: from pay_legislation_rules lr

1764: --Cursor for getting the Soft coding structure id from business group id.
1765: --
1766: cursor csr_soft_id_flex_num(c_legislation_code pay_legislation_rules.legislation_code%TYPE ) is
1767: select lr.rule_mode
1768: from pay_legislation_rules lr
1769: where lr.legislation_code = c_legislation_code
1770: and upper(lr.rule_type) = 'S';
1771:
1772: --