APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on PAY_RUN_RESULTS

Line 47: p_element_entry_id in PAY_RUN_RESULTS.SOURCE_ID%TYPE,

43: PROCEDURE Fetch_Balances(
44: p_assignment_id in PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE,
45: p_element_type_id in PAY_ELEMENT_TYPES_F.ELEMENT_TYPE_Id%TYPE,
46: p_element_name in PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
47: p_element_entry_id in PAY_RUN_RESULTS.SOURCE_ID%TYPE,
48: p_itd_balance OUT NOCOPY NUMBER,
49: p_ptd_balance OUT NOCOPY NUMBER
50: ) is
51:

Line 63: from pay_run_results prr,

59: p_ent_id in NUMBER,
60: p_element_type_id in NUMBER) is
61: select prr.assignment_action_id,
62: prr.source_id
63: from pay_run_results prr,
64: pay_element_types_f ele
65: where prr.assignment_action_id in (
66: SELECT /*+ use_nl(paa,ppa,ptp,ses) */
67: to_number(substr(max(lpad(paa.action_sequence,15,'0')||

Line 91: from pay_run_results prr,

87: p_ent in NUMBER,
88: p_element_type_id in NUMBER) is
89: select prr.assignment_action_id,
90: prr.source_id
91: from pay_run_results prr,
92: pay_element_types_f ele
93: where prr.assignment_action_id in (
94: SELECT /*+ use_nl(paa,ppa,ptp,ses) */
95: to_number(substr(max(lpad(paa.action_sequence,15,'0')||

Line 118: l_itd_source_id PAY_RUN_RESULTS.source_id%TYPE;

114: and prr.source_id = p_ent;
115:
116: l_proc VARCHAR(72) := g_package||'.FETCH_BALANCES';
117: l_itd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
118: l_itd_source_id PAY_RUN_RESULTS.source_id%TYPE;
119: l_ptd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
120: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;
121: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;
122: l_balance_type_id2 PAY_BALANCE_TYPES.balance_type_id%TYPE;

Line 120: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;

116: l_proc VARCHAR(72) := g_package||'.FETCH_BALANCES';
117: l_itd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
118: l_itd_source_id PAY_RUN_RESULTS.source_id%TYPE;
119: l_ptd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
120: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;
121: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;
122: l_balance_type_id2 PAY_BALANCE_TYPES.balance_type_id%TYPE;
123: l_effective_date DATE;
124: l_name PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;

Line 1443: FROM pay_run_results prr,

1439:
1440: CURSOR csr_get_reference
1441: IS
1442: SELECT nvl(prrv.result_value,'Unknown')
1443: FROM pay_run_results prr,
1444: pay_run_result_values prrv,
1445: pay_assignment_actions pac,
1446: pay_input_values_f piv ,
1447: pay_payroll_actions ppa

Line 1459: pay_run_results prr1,

1455: and ppa.action_type in ('R','Q')
1456: AND ppa.payroll_action_id = pac.payroll_action_id
1457: AND pac.assignment_action_id = (SELECT max(pac1.assignment_action_id)
1458: FROM pay_assignment_actions pac1,
1459: pay_run_results prr1,
1460: pay_payroll_actions ppa1
1461: WHERE pac1.assignment_action_id <> p_asg_action_id
1462: AND pac1.assignment_action_id = prr1.assignment_action_id
1463: AND ppa1.payroll_action_id = pac1.payroll_action_id

Line 1479: FROM pay_run_results PRR,

1475:
1476: CURSOR csr_get_results
1477: IS
1478: SELECT PRR.run_result_id
1479: FROM pay_run_results PRR,
1480: pay_assignment_actions ASA,
1481: pay_payroll_actions PPA
1482: WHERE PRR.source_id = p_element_entry_id
1483: AND PRR.source_type IN ('E', 'I')

Line 1492: FROM pay_run_results prr2

1488: and ppa.action_type in ('R','Q')
1489: AND PPA.payroll_action_id = ASA.payroll_action_id
1490: -- Check whether the run_result has been revered.
1491: AND not exists (SELECT null
1492: FROM pay_run_results prr2
1493: WHERE prr2.source_id = PRR.run_result_id
1494: AND prr2.source_type in ('R', 'V'));
1495: --
1496: