APPS.PAY_COSTING_KFF_UTIL_PKG dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 560: from pay_cost_allocation_keyflex E,

556: , 'SEGMENT28', nvl(E.segment28, nvl(A.segment28, nvl(O.segment28, nvl(L.segment28, P.segment28))))
557: , 'SEGMENT29', nvl(E.segment29, nvl(A.segment29, nvl(O.segment29, nvl(L.segment29, P.segment29))))
558: , 'SEGMENT30', nvl(E.segment30, nvl(A.segment30, nvl(O.segment30, nvl(L.segment30, P.segment30))))
559: , null ) segment_value
560: from pay_cost_allocation_keyflex E,
561: pay_cost_allocation_keyflex A,
562: pay_cost_allocation_keyflex O,
563: pay_cost_allocation_keyflex L,
564: pay_cost_allocation_keyflex P,

Line 561: pay_cost_allocation_keyflex A,

557: , 'SEGMENT29', nvl(E.segment29, nvl(A.segment29, nvl(O.segment29, nvl(L.segment29, P.segment29))))
558: , 'SEGMENT30', nvl(E.segment30, nvl(A.segment30, nvl(O.segment30, nvl(L.segment30, P.segment30))))
559: , null ) segment_value
560: from pay_cost_allocation_keyflex E,
561: pay_cost_allocation_keyflex A,
562: pay_cost_allocation_keyflex O,
563: pay_cost_allocation_keyflex L,
564: pay_cost_allocation_keyflex P,
565: pay_element_links_f EL,

Line 562: pay_cost_allocation_keyflex O,

558: , 'SEGMENT30', nvl(E.segment30, nvl(A.segment30, nvl(O.segment30, nvl(L.segment30, P.segment30))))
559: , null ) segment_value
560: from pay_cost_allocation_keyflex E,
561: pay_cost_allocation_keyflex A,
562: pay_cost_allocation_keyflex O,
563: pay_cost_allocation_keyflex L,
564: pay_cost_allocation_keyflex P,
565: pay_element_links_f EL,
566: hr_all_organization_units OU,

Line 563: pay_cost_allocation_keyflex L,

559: , null ) segment_value
560: from pay_cost_allocation_keyflex E,
561: pay_cost_allocation_keyflex A,
562: pay_cost_allocation_keyflex O,
563: pay_cost_allocation_keyflex L,
564: pay_cost_allocation_keyflex P,
565: pay_element_links_f EL,
566: hr_all_organization_units OU,
567: pay_payrolls_f PP,

Line 564: pay_cost_allocation_keyflex P,

560: from pay_cost_allocation_keyflex E,
561: pay_cost_allocation_keyflex A,
562: pay_cost_allocation_keyflex O,
563: pay_cost_allocation_keyflex L,
564: pay_cost_allocation_keyflex P,
565: pay_element_links_f EL,
566: hr_all_organization_units OU,
567: pay_payrolls_f PP,
568: pay_element_entries_f EE,

Line 646: from pay_cost_allocation_keyflex E,

642: , 'SEGMENT28', nvl(E.segment28, nvl(L.segment28, P.segment28))
643: , 'SEGMENT29', nvl(E.segment29, nvl(L.segment29, P.segment29))
644: , 'SEGMENT30', nvl(E.segment30, nvl(L.segment30, P.segment30))
645: , null) segment_value
646: from pay_cost_allocation_keyflex E,
647: pay_cost_allocation_keyflex L,
648: pay_cost_allocation_keyflex P,
649: pay_element_links_f EL,
650: pay_payrolls_f PP,

Line 647: pay_cost_allocation_keyflex L,

643: , 'SEGMENT29', nvl(E.segment29, nvl(L.segment29, P.segment29))
644: , 'SEGMENT30', nvl(E.segment30, nvl(L.segment30, P.segment30))
645: , null) segment_value
646: from pay_cost_allocation_keyflex E,
647: pay_cost_allocation_keyflex L,
648: pay_cost_allocation_keyflex P,
649: pay_element_links_f EL,
650: pay_payrolls_f PP,
651: pay_element_entries_f EE,

Line 648: pay_cost_allocation_keyflex P,

644: , 'SEGMENT30', nvl(E.segment30, nvl(L.segment30, P.segment30))
645: , null) segment_value
646: from pay_cost_allocation_keyflex E,
647: pay_cost_allocation_keyflex L,
648: pay_cost_allocation_keyflex P,
649: pay_element_links_f EL,
650: pay_payrolls_f PP,
651: pay_element_entries_f EE,
652: per_all_assignments_f ASG

Line 704: -- pay_cost_allocation_keyflex if the combination is valid and doesn't

700: --
701: -- Description:
702: -- Performs validation of the cost allocation specified by
703: -- p_concat_segments. A cost allocation entry is created in
704: -- pay_cost_allocation_keyflex if the combination is valid and doesn't
705: -- already exist. Returns the id of the combination if it is valid via
706: -- p_cost_allocation_keyflex_id, otherwise returns error information via
707: -- p_error_segment_num, p_error_segment_name and p_error_message.
708: --

Line 778: update pay_cost_allocation_keyflex

774: --
775: -- update the cost allocation keyflex table with the concatenated
776: -- segments
777: --
778: update pay_cost_allocation_keyflex
779: set concatenated_segments = p_concat_segments
780: where cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
781: commit;
782: --