APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on FF_FUNCTIONS

Line 377: FROM ff_functions

373: elsif l_source_name = 'Function' THEN
374: begin
375: SELECT definition
376: INTO l_package
377: FROM ff_functions
378: WHERE name = l_function_name
379: and business_group_id = g_business_group_id;
380:
381: --EXECUTE IMMEDIATE 'CALL ' || l_package || '() INTO :l_hours_worked' USING OUT l_hours_worked;

Line 608: FROM ff_functions

604:
605: begin
606: SELECT definition
607: INTO l_package
608: FROM ff_functions
609: WHERE name = l_function_name
610: and business_group_id = g_business_group_id;
611:
612: --EXECUTE IMMEDIATE 'CALL ' || l_package || '() INTO :l_periods_covered' USING OUT l_periods_covered;

Line 762: FROM ff_functions

758:
759: begin
760: SELECT definition
761: INTO l_package
762: FROM ff_functions
763: WHERE name = l_function_name
764: and business_group_id = g_business_group_id;
765:
766: --EXECUTE IMMEDIATE 'CALL ' || l_package || '() INTO :l_periods_covered' USING OUT l_irregular_payment;

Line 918: FROM ff_functions

914:
915: begin
916: SELECT definition
917: INTO l_package
918: FROM ff_functions
919: WHERE name = l_function_name
920: and business_group_id = g_business_group_id;
921:
922: hr_utility.trace('l_package'||l_package);

Line 1060: FROM ff_functions

1056:
1057: begin
1058: SELECT definition
1059: INTO l_package
1060: FROM ff_functions
1061: WHERE name = l_function_name
1062: and business_group_id = g_business_group_id;
1063:
1064: hr_utility.trace('l_package'||l_package);

Line 1202: FROM ff_functions

1198:
1199: begin
1200: SELECT definition
1201: INTO l_package
1202: FROM ff_functions
1203: WHERE name = l_function_name
1204: and business_group_id = g_business_group_id;
1205:
1206: hr_utility.trace('l_package'||l_package);

Line 1343: FROM ff_functions

1339:
1340: begin
1341: SELECT definition
1342: INTO l_package
1343: FROM ff_functions
1344: WHERE name = l_function_name
1345: and business_group_id = g_business_group_id;
1346:
1347: hr_utility.trace('l_package'||l_package);

Line 1488: FROM ff_functions

1484:
1485: begin
1486: SELECT definition
1487: INTO l_package
1488: FROM ff_functions
1489: WHERE name = l_function_name
1490: and business_group_id = g_business_group_id;
1491:
1492: hr_utility.trace('l_package'||l_package);