APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 44: p_assignment_id in PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE,

40: -- Public Declarations
41: --
42:
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,

Line 69: FROM pay_assignment_actions paa,

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')||
68: paa.assignment_action_id),16))
69: FROM pay_assignment_actions paa,
70: pay_payroll_actions ppa,
71: per_time_periods ptp,
72: fnd_sessions ses
73: WHERE paa.assignment_id = p_asg

Line 96: FROM pay_assignment_actions paa,

92: where prr.assignment_action_id in (
93: SELECT /*+ use_nl(paa,ppa,ptp,ses) */
94: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
95: paa.assignment_action_id),16))
96: FROM pay_assignment_actions paa,
97: pay_payroll_actions ppa,
98: fnd_sessions ses,
99: per_time_periods ptp
100: WHERE paa.assignment_id = p_asg

Line 115: l_itd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;

111: and ele.element_type_id = p_element_type_id
112: and prr.source_id = p_ent;
113:
114: l_proc VARCHAR(72) := g_package||'.FETCH_BALANCES';
115: l_itd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
116: l_itd_source_id PAY_RUN_RESULTS.source_id%TYPE;
117: l_ptd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;
118: l_ptd_source_id PAY_RUN_RESULTS.source_id%TYPE;
119: l_balance_type_id PAY_BALANCE_TYPES.balance_type_id%TYPE;

Line 117: l_ptd_action_id PAY_ASSIGNMENT_ACTIONS.assignment_action_id%TYPE;

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

Line 1443: pay_assignment_actions pac,

1439: IS
1440: SELECT nvl(prrv.result_value,'Unknown')
1441: FROM pay_run_results prr,
1442: pay_run_result_values prrv,
1443: pay_assignment_actions pac,
1444: pay_input_values_f piv ,
1445: pay_payroll_actions ppa
1446: WHERE prr.run_result_id = prrv.run_result_id
1447: AND prr.entry_type = 'E'

Line 1455: FROM pay_assignment_actions pac1,

1451: AND pac.action_status in ('C')
1452: and ppa.action_type in ('R','Q')
1453: AND ppa.payroll_action_id = pac.payroll_action_id
1454: AND pac.assignment_action_id = (SELECT max(pac1.assignment_action_id)
1455: FROM pay_assignment_actions pac1,
1456: pay_run_results prr1,
1457: pay_payroll_actions ppa1
1458: WHERE pac1.assignment_action_id <> p_asg_action_id
1459: AND pac1.assignment_action_id = prr1.assignment_action_id

Line 1476: pay_assignment_actions ASA,

1472: CURSOR csr_get_results
1473: IS
1474: SELECT PRR.run_result_id
1475: FROM pay_run_results PRR,
1476: pay_assignment_actions ASA,
1477: pay_payroll_actions PPA
1478: WHERE PRR.source_id = p_element_entry_id
1479: AND PRR.source_type IN ('E', 'I')
1480: AND PRR.status in ('P', 'PA', 'R', 'O')